<? include("connection.php");
@$cat=$_REQUEST['cat'];
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3c.org/TR/1999/REC-html401-19991224/loose.dtd">
<HTML>
<HEAD><TITLE><?=@$site_title?></TITLE>
<meta name="keywords" content="<?=@$site_keywords?>">
<meta name="description" content="<?=@$site_description?>">
<link href="css/generic.css" rel="stylesheet" type="text/css" />
<link href="style.css" rel="stylesheet" type="text/css" />
</head>
<body>
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="100%" colspan="2" align="left" valign="top" ><? include("header.php");?></td>
</tr>
<tr>
<td colspan="2" align="left" valign="top">
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="160" valign="top" background="images/left_bg.gif" bgcolor="#DCE6F0"><? $pg="bu";
include("left.php")?></td>
<td width="70%" valign="top"><table width="98%" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="left" valign="top" class="bodytext5"><h3><? echo @$cityname; if(@$cityname!='' && @$catname!='') { echo " - "; }?>
<?=@$catname?>
</h3></td>
</tr>
</table></td>
</tr>
<tr>
<td height="270" valign="top" background="images/mainbgbg.jpg" style="background-repeat:repeat-x; "><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><table width="100%" border="0" cellpadding="0" cellspacing="0" class="tableblue1">
<tr>
<td ><table width="98%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr align="left">
<td class="bodytext4"> </td>
</tr>
<tr align="left">
<td class="bodytext5">Bussiness Listings </td>
</tr>
<tr>
<td><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="5" ></td>
</tr>
<tr>
<td height="25" align="left" class="bodytext" ><span class="bodytext1">
<?
include ("paging.inc.php");
$limit=10;
@$city=$REQUEST['city'];
@$cat=$REQUEST['cat'];
@$key=$_REQUEST['key'];
$query="select * from advert a, category c, city ct where ct.city_id=a.a_location and a.a_status!='Deactive' and a.cat_id=c.cat_id ";
if ($cat!=""){
$query .=" and (a.cat_id='$cat' or c.cat_parent='$cat')";
}
if ($city!=""){
$query .=" and a.a_location='$city'";
}
if ($key!=""){
$query .=" and a.a_services like '%$key%' ";
}
[COLOR="Red"][B] $query .=" order by a.a_paid desc";[/B][/COLOR] $result=mysql_query($query);
$query=paging_1($query,"","0%");
$result=mysql_query($query);
?>
</td>
</tr>
<tr>
<td bgcolor="#999933"> </td>
</tr>
<? if($cat!='' || $key!='' || $city!=''){
while($row=mysql_fetch_array($result)){
$d++;
if($row['a_paid']=='Y'){ $class='paidlisting'; }else{$class='freelisting';}
?>
<tr>
<td height="25" class="<?=$class?>" style="padding:5px 5px 5px 5px">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="left"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="1%" valign="top" style="padding-top:5px "><img src="images/arrow.gif" width="7" height="6"></td>
<td width="79%" class="moreinfo"> <span class="bodytext4">
<?=$d?>
.</span><span class="footertext4"> </span>
<? if($row['a_paid']=='Y'){ ?>
<a href='details.php?id=<?=$row['a_id']?>' class="moreinfo" title='<?=$row['a_title']?>'>
<?=$row['a_title']?>
</a>
<? }else{?>
<?=$row['a_title']?>
<? }?><br>
<span class="bodytext2">
<strong>Address :</strong>
<?=$row['a_address']?>
,
<?=$row['city_name']?>
,<?=$row['a_pin']?> , <?=$row['a_country']?>
<strong>Phone:</strong>
<?=$row['a_phone']?>
</span></td>
<td width="20%" align="right" valign="top" class="bodytext2" ><? if($row['a_paid']=='Y'){
?>
<table width="150" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="25" align="right"><img src="images/icon_web.gif"></td>
<td align="left"> <a href="details.php?id=<?=$row['a_id']?>" target="_blank" class="bodytext2"><strong > View Details</strong></a></td>
</tr>
</table>
<? }?> </td>
</tr>
</table></td>
</tr>
<tr>
<td align="left"><span class="bodytext">
<?=$row['a_services']?>
</span></td>
</tr>
<tr>
<td height="10" align="left" ></td>
</tr>
<tr>
<td height="10" align="left" > </td>
</tr>
</table></td>
</tr>
<tr>
<td align="left" > </td>
</tr>
<? } ?>
<tr>
<td height="5" ></td>
</tr>
<tr>
<td height="5" align="right" ><span class="bodytext1">
<?
@$str="v=$v&cat=$cat&city=$city&key=$key&d=$d";
paging_2($str,"0%");
?>
</span></td>
</tr><? }?>
<tr>
<td height="5" ></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
<tr>
<td height="5"> </td>
</tr>
<tr>
<td height="5" align="center"><!--<? banner($city, $cat, 1, 'Body');?>--></td>
</tr>
<tr>
<td height="5"> </td>
</tr>
</table></td>
</tr>
</table></td>
<td width="15%" valign="top" background="images/right_bg.gif" bgcolor="#DCE6F0"><? include("right.php")?></td>
</tr>
</table></td>
</tr>
<tr>
<td colspan="2" align="left" valign="top"><? include("footer.php");?></td>
</tr>
</table>
</body>
</html>
