Please help - should be a simple fix.. driving me nuts

[JTapp]

Everything seemed to be working fine.  I have a table, it alphabetically lists a bunch of cities and relivant city data.

 

However, I found out that the city is showing up only one time when I have can have more than one rows with that City name..  I.e. - I should have 15 rows that are all "Jacksonville" but I am only seeing one.  I guess my code is eliminating what it thinks are duplicates?

 

Here is my code (I renamed field names for communication purposes)

 

 

 

$dbhandle = mysql_connect($hostname, $username, $password)

or die("Unable to connect to MySQL");

 

$selected = mysql_select_db("companies",$dbhandle)

or die("Could not select companies");

 

$query = mysql_query("SELECT* FROM companies GROUP BY City");

while ($row = @mysql_fetch_array($query))

 

 

{

 

$variable1=$row["Email"];

$variable2=$row["WEB"];

 

 

 

echo "<tr bgcolor=\"#dddddd\"><td><center>";

echo $row["City"];

echo ($variable2 != '') ? "<a href=\"$variable2\"></br> Website</a>" : '';

echo ($variable1 != '') ? "<a href=\"mailto:$variable1\">Email</a>" : '';

echo ltrim($row[""], '0');

}?>

         

 

 

 

[mrMarcus]

perhaps your GROUP BY is dong it?  you try the same query without?

[Calver]

Did you want to sort by City - 'ORDER BY City' instead of 'GROUP BY City' ?

 

[JTapp]

Worked like a charm.  Thank you very much!