hi, got a sql statement, prettystraight forward:
$sql = "SELECT Psuburb FROM WB_listings ORDER BY Psuburb ASC";
//Create recordset called $rsstock
$rssuburbs = mysql_query($sql,$connect);
//Find out how many records in the recordset
$rows = mysql_fetch_assoc($rssuburbs);
everything works fine… BUT. in my Psuburb column there is multiple entries for one place, ex. 5 Durbanville’s, 10 Kraaifontain’s, etc… I only want to display one of each. i.e. this displays in a dropdown list on a property website, so the people can search what propeties are listed in the different suburbs.
I’m sure this must be very easy, I’m just missing something.
Hope you can help!
Thx!