Code: Select all
Warning: implode() [function.implode]: Bad arguments. in /..../......./......_....../wanted.catlistings.php on line 133
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /..../......./......_....../wanted.catlistings.php on line 165Code: Select all
<?
// newest function
if ($_GET['start'] == "") $start = 0;
else $start = $_GET['start'];
$limit = 20;
$croot = $_REQUEST['parent'];
$cntr=0;
while ($croot>0) {
$crw = getSqlRow("SELECT * FROM probid_categories WHERE id='$croot'");
if($cntr == 0) {
$catname = $crw['name'];
} else {
if($crw['parent'] != $croot) {
$catname = "$crw[name] : $catname";
}
}
$cntr++;
$croot = $crw['parent'];
}
$catname = trim($catname);
$mysqlVersion = substr(mysql_get_server_info(),0,1);
## get all subcats
reset($cat_array);
if ($catname!="") {
while (list($cat_array_id, $cat_array_details)=each($cat_array)) {
list($cat_array_name, $userid) = $cat_array_details;
$strResult = strpos($cat_array_name,$catname);
if (trim($strResult)=="0") $cat_id[$catcnt++] = $cat_array_id;
}
$all_subcats = implode (",",$cat_id);
$subcatquery="(a.category IN (".$all_subcats.") OR a.addlcategory IN (".$all_subcats.")) AND ";
} else {
$subcatquery = "";
}
if ($mysqlVersion>=4) {
$additionalQuery = "SQL_CALC_FOUND_ROWS ";
} else {
## this is only used if the mySql is older than v4. Slower version
$nbItems = getSqlNumber("SELECT DISTINCT a.id, a.itemname,
a.nrbids, a.enddate FROM probid_wanted_ads a WHERE
".$subcatquery."
a.active=1 AND a.closed=0 AND a.deleted!=1
ORDER BY a.".$orderField." ".$orderType);
}
$getAds = mysql_query("SELECT ".$additionalQuery." DISTINCT a.id, a.itemname,
a.nrbids, a.enddate, a.picpath FROM probid_wanted_ads a WHERE
".$subcatquery."
a.active=1 AND a.closed=0 AND a.deleted!=1
ORDER BY a.".$orderField." ".$orderType." LIMIT $start,$limit");
if ($mysqlVersion>=4) $nbItems = mysql_result(mysql_query("Select FOUND_ROWS() AS nbr"),0,"nbr");
if ($nbItems==0) {
echo "<tr><td colspan=5 class=contentfont align=center>".$lang[nowanted]."</td></tr>";
} else {
if ($nbItems>($start+$limit)) $final = $start+$limit;
else $final = $nbItems;
while ($ad = mysql_fetch_array($getads)) { ?>
<tr class="<? echo (($count++)%2==0)?"c2":"c3"; ?>">
<td align="center"><?
if ($ad['picpath']!="") {
echo "<a href=\"wanted.details.php?id=".$ad['id']."\"><img src=\"makethumb.php?pic=".$ad['picpath']."&w=40&sq=Y&b=Y\" border=0></a>";
} else echo "N/A"; ?>
</td>
<td nowrap="nowrap" class=contentfont><a href="wanted.details.php?id=<?=$ad['id'];?>">
<?=$ad['itemname'];?>
</a></td>
<td class=contentfont align="center"><b>
<?=$ad['nrbids'];?>
</b> </td>
<td align="center" class=contentfont><? echo timeleft($ad['enddate'],$setts['date_format']);?></td>
</tr>
<? } ?>
<tr>
<td colspan=5 class=contentfont align=center><?
paginate($start,$limit,$nbItems,"wanted.categories.php","&parent=".$_REQUEST['parent']."&orderField=$orderField&orderType=$orderType");
?></td>
</tr>
<? }?>
</table></td>
</tr>
</table>If you can see a bug/error and can help i would be very greatful!
Adam.[/syntax]