............All Makes .................... $today=date("Y-m-d G:i:s"); $SqlMakers="SELECT * FROM ".TABLEPREFIX."_makers WHERE IsActive='Y' ORDER BY MakerName"; $RsMakers=mysql_query($SqlMakers) or die(mysql_error()); WHILE($RowMakers=mysql_fetch_array($RsMakers)) { $NumMk=mysql_result(mysql_query("SELECT Count(*) FROM ".TABLEPREFIX."_advertdetails WHERE MakerID='$RowMakers[MakerID]' AND IsActive='Y'"),0,0); if($NumMk>0) { $SqlExpiryCheck="SELECT ad.*,act.* FROM ".TABLEPREFIX."_advertdetails ad , ".TABLEPREFIX."_accounts act WHERE ad.MakerID='$RowMakers[MakerID]' AND act.SubscriptionExpiry>'$today' AND ad.IsActive='Y' AND ad.AccountID=act.AccountID"; if(mysql_num_rows(mysql_query($SqlExpiryCheck))>0) { ?> echo $RowMakers[MakerName]."(".$NumMk.")"?> } } }?>
............All Models....................
$sql_location="select * from auto_carlocation where 1"; $location_rs=mysql_query($sql_location); ?> ............All Locations ................ while($row_location=mysql_fetch_array($location_rs)) { ?> =$row_location[Location]?> } ?>
Year Min. Year Max.
Price Min Price Max