I am trying to figure out a way to restrict a query to excude duplications. There is a table that supplies 2 dropdown tables, one for suburbs and another field for postcodes. The administrator can insert new suburbs and postcodes but sometimes several of the suburbs have the same postcodes. Therefore, needless to say, the postcode dropdown ends up with extraneous postcodes.
Code: Select all
mysql_select_db($database_connect_form, $connect_form);
$query_qArea = "SELECT town, postcode FROM areas";
$qArea = mysql_query($query_qArea, $connect_form) or die(mysql_error());
$row_qArea = mysql_fetch_assoc($qArea);
$totalRows_qArea = mysql_num_rows($qArea);Thanks