at lave om på kategorie
HiJeg har brug for hjælp til :
1. at har en mellem rum mellem
kategoriet og (kategoriet tal)
2. at vise kategorier i 2 kolumn istød for 3
Tak
---------------------------
<td valign="top"><table width="90%" border="0" align="center" cellpadding="0" cellspacing="0" >
<tr>
<td><font class="normal"> <a href="index.php">Home</a><? echo $catpath;?></font></td>
</tr>
<tr>
<td><table width="100%" border="0" align="center" cellpadding="0" cellspacing="1" class="titlestyle">
<tr>
<td align="center" valign="middle" class="subtitle" >→
<a href="cat_sell.php<?php if($cid<>0) echo "?cid=".$cid;?>">Sell Offers</a></td>
<td align="center" valign="middle">↓ Buy Offers</td>
<td align="center" valign="middle" class="subtitle" >→
<a href="cat_products.php<?php if($cid<>0) echo "?cid=".$cid;?>">Products</a></td>
<td align="center" valign="middle" class="subtitle" >→
<a href="cat_profiles.php<?php if($cid<>0) echo "?cid=".$cid;?>">Companies</a></td>
</tr>
</table></td>
</tr>
</table></td>
</tr><?php
?><tr>
<td valign="top"> <table width="90%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><font class="normal"><b>Browse Buy Offers</b></font></td>
</tr>
<td class="onepxtable"><table width="100%" border="0" cellspacing="1" cellpadding="2" class="innertablestyle">
<?
$cats_sql="select * from sbbleads_categories where sb_pid=$cid ";
if($config["sb_cat_listing"]=="alpha")
{
$cats_sql.=" order by sb_cat_name";
}
else
{
$cats_sql.=" order by sb_order_index";
}
$cats_query=mysql_query($cats_sql);
$cnt=1;
while($cats=mysql_fetch_array($cats_query))
{
$rst_query=mysql_query("Select * from sbbleads_categories where sb_pid=".$cats["sb_id"] );
$clist=$cats["sb_id"];
while ( $rst=mysql_fetch_array($rst_query) )
{
$clist.="," . $rst["sb_id"];
$thislist="-1," . $rst["sb_id"];
while ( $rst=mysql_fetch_array($rst_query) )
{
$clist.="," . $rst["sb_id"];
$thislist.="," . $rst["sb_id"];
//echo $rst["sbcat_id"];
}
$rst_query=mysql_query("Select * from sbbleads_categories where sb_pid in (" . $thislist . ")" );
}
$sbcat_str= " and sb_cid IN (" .$clist . ")" ;
$sbq_off_cat="select * from sbbleads_offer_cats, sbbleads_offers where sb_approved='yes' and sbbleads_offers.sb_id=sbbleads_offer_cats.sb_offer_id and DATE_ADD(sb_postedon,INTERVAL ".$config["sb_expiry_sell"]." MONTH) > NOW() $sbcat_str";
$sboff_count=mysql_num_rows(mysql_query($sbq_off_cat));
$sbq_buy_cat="select * from sbbleads_offer_cats_buy, sbbleads_offers_buy where sb_approved='yes' and sbbleads_offers_buy.sb_id=sbbleads_offer_cats_buy.sb_offer_id and DATE_ADD(sb_postedon,INTERVAL ".$config["sb_expiry_buy"]." MONTH) > NOW() $sbcat_str";
$sbbuy_count=mysql_num_rows(mysql_query($sbq_buy_cat));
$sbq_product_cat="select * from sbbleads_product_cats, sbbleads_products where sb_approved='yes' and sbbleads_products.sb_id=sbbleads_product_cats.sb_offer_id $sbcat_str";
$sbproduct_count=mysql_num_rows(mysql_query($sbq_product_cat));
$sbq_profile_cat="select * from sbbleads_profile_cats, sbbleads_companyprofiles where sb_approved='yes' and sbbleads_companyprofiles.sb_id=sbbleads_profile_cats.sb_profile_id $sbcat_str";
$sbprofile_count=mysql_num_rows(mysql_query($sbq_profile_cat));
$sbtotal=$sbbuy_count;//$sboff_count+$sbbuy_count+$sbproduct_count+$sbprofile_count;
//die();
if($cnt%3==1)
{
?>
<tr>
<td width="20"> </td>
<?
}
?>
<td align="left"><font class='normal'> <a href="index.php?cid=<? echo $cats["sb_id"];?>">
</a><a href="cat_buy.php?cid=<? echo $cats["sb_id"];?>"><? echo $cats["sb_cat_name"]; ?></a>(<? echo $sbtotal; ?>)</font></td>
<?
if($cnt%3==0)
{
?>
</tr>
<?
}
$cnt++;
}
?>
</table></td>
</tr>
</table>
------------------------
