$prev_time ORDER BY created;";
}
else {
if($type == 'All Types') {
if($_POST['location'] == 'All Areas') {
//query all adverts
$query = "SELECT * FROM adverts WHERE created > $prev_time ORDER BY created;";
}
else {
//query by location only
$query = "SELECT * FROM adverts, clients WHERE clients.locationID='$loc' AND adverts.created > $prev_time AND adverts.userID = clients.userID ORDER BY adverts.created;";
}
}
else {
if($_POST['location'] == 'All Areas') {
//query by type only
$query = "SELECT * FROM adverts, clients WHERE clients.type='$type' AND adverts.created > $prev_time AND adverts.userID = clients.userID ORDER BY adverts.created;";
}
else {
//query by both parameters
$query = "SELECT * FROM adverts, clients WHERE clients.type='$type' AND clients.locationID='$loc' AND adverts.created > $prev_time AND adverts.userID = clients.userID ORDER BY adverts.created;";
}
}
}
//end of sql query options
$result = mysql_query($query) or die('Query failed: ' . mysql_error());
echo "
";
echo "
";
while($adv = mysql_fetch_assoc($result)) {
$d = date('M d, H:i', $adv['created']);
$c_row = get_client_record_id($adv['userID']);
$loc = get_location_desc($c_row['locationID']);
echo "
";
}
echo '
';
echo "
";
?>