help with my sql sintax

[aron]

it dosent work.

elseif ($order == 'suburb') {
$sql = "SELECT DISTINCT A1.propert_id, A1.open_date, A1.24hr_time, A2.id, A2.suburb, FROM open_house A1, Listings A2 WHERE A1.open_date>='$date_today' ORDER BY A2.suburb, A1.open_date, A1.24hr_time ASC";
}

aron.

[freebie]

Here's the problem:

A2.suburb, FROM open_house

remove the comma after the last field before the FROM

-hth

[BooRadLey]

Try this one out:

elseif ($order == 'suburb') { 
$sql = "SELECT DISTINCT A1.propert_id, A1.open_date, A1.24hr_time, A2.id, A2.suburb FROM open_house A1, Listings A2 WHERE A1.open_date>='".$date_today."' ORDER BY A2.suburb, A1.open_date, A1.24hr_time ASC"; 
}