In mysql table info
i have :
Id , Name , City , date , status
I want to select all names from "info" Making the query
$query = mysql_query("SELECT name FROM info WHERE status = 1 ORDER BY id")
or die(mysql_error());
while ($raw = mysql_fetch_array($query))
{
$name = $raw["name"];
echo ''.$name.'<br>';
}
Well, the result is that it returns all the entries. I want to echo all the entries without duplicates.
Saying: under raw "name" we have inserted the name "John" 10 times.
I want to echo only one time.
Is this possible?