Retrieve only one record based on name

Question

I have 3 columns name,id,amount. I created 5 rows with same name. Now i retrieve one row which is topped. Here i added my code,

<?php
$name = "SELECT DISTINCT name
FROM calculation";
$query = mysqli_query($conn,$name);

$count = mysqli_num_rows($query);
while($row = mysqli_fetch_assoc($query)){

echo "<div class='container'>
        <table class='table'>
    <thead>
      <tr>
        <th>Firstname</th>
        <th>Lastname</th>
        <th>Email</th>
      </tr>
    </thead>
    <tbody>
      <tr>
        <td>".$row['name']."</td>
        <td>".$row['phone']."</td>
        <td>".$row['balance']."</td>
      </tr></table></div>";
               }    
                mysqli_close($conn);
                     ?>

"I retrieve one row which is topped" - What do you mean? How is the row you want returned determined? — JimmyB, Mar 21 '16 at 09:45
Use your phpmyadmin SQL tab (if youre working with it), and try some queries. Like : SELECT min( id ) AS ID FROM test WHERE name = 'value1'; — Dan Costinel, Mar 21 '16 at 09:50
i want to avoid all rows exect one based on their amount value — Sri, Mar 21 '16 at 09:51
Your query only selects the `name` column. What do you expect to find in `$row['phone']` and `$row['balance']` when you didn't request those columns? — Barmar, Mar 21 '16 at 09:52
we have few rows each one differentiate from amount value so i need to take row depend upon least amount value — Sri, Mar 21 '16 at 09:53
hi i want to find month difference between mysql stored date and current date using php or jquery is there any way to find that — Sri, Mar 22 '16 at 08:59

Amit Rajput · Answer 1 · 2016-03-21T09:43:52.717

0

Use GROUP BY or LIMIT like this:

$name = "SELECT name
FROM calculation GROUP BY name";

OR

$name = "SELECT name
FROM calculation LIMIT 1";

edited Mar 21 '16 at 09:43

answered Mar 21 '16 at 09:42

Amit Rajput

2,061
1
9
27

Why use `DISTINCT` with `GROUP BY`? – JimmyB Mar 21 '16 at 09:43

score 0 · Answer 2 · answered Mar 21 '16 at 09:44

0

Use the LIMIT clause in your SQL query:

$name = "SELECT DISTINCT name
FROM calculation
LIMIT 1";

answered Mar 21 '16 at 09:44

SGR

403
5
16

Retrieve only one record based on name

2 Answers2