Hi,
I have a search form to which I’m trying to add another drop down.
I have a table called “properties” which has a column titled “address_city” which I’m trying to pull results from. I’ve been playing with what I have below but I just cant get it to work. Please could someone advise me where I’m going wrong?
Thanks in advance…
[php] <?php echo $PL_LANG['property_choose']; ?>
<?php
$sql = “SELECT DISTINCT address_city FROM “.$TABLES[‘properties’].” ORDER BY title;”;
{
?>
<?php echo $row['address_city'];?>
<?php
}
?>[/php]