second set of categories problem php

by 6 replies
7
i have created a second set of cats, for my website but when i click one of the categories it results in showing all listings and not the selected category listings

<?
require_once('config/config.php');
$where="";
if($_REQUEST['site_status_name']!="")
{
$where.=" AND site_status_name='".$_REQUEST['site_status_name']."'";
}
if($_REQUEST['keytxt']!="")
{
$where.=" AND (price like '%".escapeQuotes(stripslashes($_REQUEST['keytxt']))."%' OR title like '%".escapeQuotes(stripslashes($_REQUEST['keytxt']))."%')";
//echo $where;
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title><?=TITLE?></title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta name="keywords" content="<?=META_KEYWORDS?>"/>
<meta name="description" content="<?=META_CONTENT?>"/>
<link href="css/fresh-auction.css" rel="stylesheet" type="text/css" />
<script type="text/javascript">
function jsHitListAction(p1)
{
document.frm.action = "<?=$_SERVER['PHP_SELF']?>?PageNo=" + eval(p1) ;
document.frm.submit()
}
</script>
</head>
<? include_once("toppage1.php");?>
<body>
<div id="container" >
<div id="contentwrapper" >
<? include_once("left-menu.php");?>
<div id="content" >
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td>

<div class="header_top">
<? include_once("cart-info.php");?>
</div>


<div class="clear"></div>


<!--div class="menu_top">
<? include_once("top-menu.php")?>
</div-->
<p><span class="header_text_h">Search All Listings!</span></p>
<p align="left">
<form name="frm" method="post" action="">
<table width="100%" border="0" cellspacing="0" cellpadding="4" class="border">
<tr>
<td width="39%" class="rowhead" align="left">Title</td>
<td width="16%" class="rowhead" align="center">Current Bid</td>
<td width="10%" class="rowhead" align="center"># of Bids</td>
<td width="12%" class="rowhead" align="center">Questions</td>
<td width="11%" class="rowhead" align="center">Ends</td>
</tr>
<?
$sql="SELECT * FROM ".ADVERTISE." WHERE status='1' ".$where." ORDER BY add_id DESC";
$PageSize =30;
$StartRow =0;
include_once('paging-top.php');
if(mysql_num_rows($rs)>0)
{
$bgColor = "#ffffff";
for($i=0;$i<mysql_num_rows($rs);$i++)
{
$arradv=mysql_fetch_array($rs);
$countBid=Select_Qry("COUNT(id) AS bid",PROPOSAL,"add_id='".$arradv['add_id']."'","","","","");
$countprop=Select_Qry("COUNT(id) AS cid",QUESTION,"add_id='".$arradv['add_id']."'","","","","");

$pending=Select_Qry("COUNT(id) as PEND",PROPOSAL,"add_id='".$arradv['add_id']."' AND accept='0'","","","","");
$reject=Select_Qry("COUNT(id) as REJ",PROPOSAL,"add_id='".$arradv['add_id']."' AND accept='1'","","","","");
?>
<? if((SITE_STATUS_ADD($arradv['statusId'])=='1') && ($arradv['site_img']=='')){?>
<tr <? if($arradv['highlight']=='1'){?> bgcolor="#fff7cc"<? }?>><td align="left" valign="top" colspan="5" <? if($arradv['rowborder']==1){?>class="rowborder"<? }?>>
<table cellpadding="0" cellspacing="0" border="0" width="100%">
<tr>
<td width="39%" align="left" class="txtLabel" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="left" width="32"><? if($arradv['featured']=='1'){?><img src="http://www.warriorforum.com/images/fd.png" border="0" alt="Featured" title="Featured" /><? }else{?><img src="http://www.warriorforum.com/images/spacer.gif" border="0" height="32" width="32"/><? }?></td>
<td width="287" align="left" style="padding-left:5px;"><a href="./<?=remspace($arradv['add_id'])?>" <? if($arradv['bold']==1){?>class="bold"<? }?>><?=substr(strip_tags($arradv['title']),0,40)?></a><br /><br /><strong>Visitors:</strong> <?=SITE_STATUS($arradv['site_status_name'])?></td>
</tr>
</table>
</td>
<td width="16%" align="center">-<?php /*?><?=$arradv['price']?><?php */?></td>
<td width="10%" align="center">-<?php /*?><?=$countBid['bid']?><?php */?></td>
<td width="12%" align="center"><?=$countprop['cid']?></td>
<td width="11%" align="center"><?=enddate($arradv['valid_till'])?></td>
</tr>
</table>
</td></tr>
<tr><td colspan="5" style="border-bottom:0px dashed #CCCCCC;"></td></tr>
<? }else{?>
<tr <? if($arradv['highlight']=='1'){?> bgcolor="#fff7cc"<? }?>><td align="left" valign="top" colspan="5" <? if($arradv['rowborder']==1){?>class="rowborder"<? }?>>
<table cellpadding="0" cellspacing="0" border="0" width="100%">
<tr>
<td width="39%" align="left" class="txtLabel" valign="top"><table width="99%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="left" width="32"><? if($arradv['featured']=='1'){?><img src="http://www.warriorforum.com/images/fd.png" border="0" alt="Featured" title="Featured" /><? } else{?><img src="http://www.warriorforum.com/images/spacer.gif" border="0" height="32" width="32" /><? }?></td>
<td width="50" align="left"><a href="./<?=remspace($arradv['add_id'])?>"><img src="websiteImage/thumb<?=$arradv['site_img']?>" border="0" class="img_border" /></a></td>
<td width="287" align="left" style="padding-left:5px;"><a href="./<?=remspace($arradv['add_id'])?>" <? if($arradv['bold']==1){?>class="bold"<? }?>><?=substr(strip_tags($arradv['title']),0,40)?></a><br /><br /><strong>Visitors:</strong> <?=SITE_STATUS($arradv['site_status_name'])?></td>
</tr>
</table>
</td>
<td width="16%" align="center">
<? if($arradv['status']==2){
$acbin=Select_Qry("bin_amt, COUNT(id) as ACCBIN",BIN,"accept > '1' AND add_id ='".$arradv['add_id']."'","","","","");
if($acbin['ACCBIN'] >0){
$price=$acbin['bin_amt'];
}else {
$price=$arradv['price'];
}
}else{
$price=$arradv['price'];
}
?>
<?=$price ?></td>
<td width="10%" align="center">
<?
if($arradv['winner_id']=="0")
{
?>
<?=$countBid['bid']?><br/><?
}else{
?><span style="color:#FF0033">Sold</span><? }?></td>
<td width="12%" align="center"><?=$countprop['cid']?></td>
<td width="11%" align="center"><?=enddate($arradv['valid_till'])?></td>
</tr>
</table>
</td></tr>
<tr><td colspan="5" style="border-bottom:0px dashed #CCCCCC;"></td></tr>
<? }?>
<?
}
?>
<tr><td colspan="5" align="right" valign="top"><? include_once('pageno.php');?></td></tr> <?
}else{
?>
<tr><td colspan="5" align="center" valign="top"><?=errormessage("No postings")?></td></tr>
<?
}
?>
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td colspan="2">&nbsp;</td>
<td>&nbsp;</td>
</tr>
</table>
</form>
</p>
<div class="sidebar_sep"></div>
</td>
</tr>
</table>
</div>
<? require_once("upper-footer.php"); ?>
</div></div></div>
<? require_once("footer.php");?>

</body>
</html>
#programming #categories #php #problem #set
  • You seem to have posted a dump of code with no explanations of how it should work and no additional files like your config and no DB structure.

    If you need help, remove all redundant stuff, leave only forms and code and explain in a few words how it should work, then describe what works wrong.

    I can give you 10-20 minutes of my time to correct your bugs, give advices or send you a piece of code to make you understand where you should move further.
    But spending here hours on understanding then correcting is not my goal on this forum. I think the others will agree with me.
    • [ 1 ] Thanks
    • [1] reply
    • im sorry i do not know anything about coding and i just copied and pasted the code from the first set of cats php page and changed the parts that said category to the new category db id which is "statusid" so i wouldnt know which bit people would need to look at which is why i pasted all code, my site is in my sig if it helps
      • [1] reply
  • ok the problem is in the visitors category , which is on most pages including home page and they link to page search1.php which should return separate results depending on which link that is clicked as a normal set of categories should, but when any of the visitor categories are click it shows all listings from all visitor cats, each listing is in both sets of categories as well e.g ad size and visitor categories
    hope this is ok paul Advert Flip - Fixed Price Advertising Marketplace

    my function for this is

    function SITE_STATUS($id)
    {
    $siteStatus=Select_Qry("*",SITE_STATUS,"statusId=' ".$id."'","","","","");
    return $siteStatus['status_name'];
    }
    function SITE_STATUS_ADD($Id)
    {
    $addspace=Select_Qry("*",SITE_STATUS,"statusId='". $id."'","","","","");
    return $addspace['add_space'];
    }
  • no problem thx for the reply
  • thx for all your help but i managed to solve the problem myself
Join the discussion

Next Topics on Trending Feed