When returning to the main page of my script sometimes I'll get the following error:

Warning: mysql_fetch_array(): 8 is not a valid MySQL result resource in /home/nick/http/search/includes/main.inc on line 13

This happens only AFTER the first element in the resource has been processed. Here's the code that is causing the problem:

$s = mysql_query("SELECT * FROM categories WHERE length(cat)='2'");
while($t = mysql_fetch_array($s)){
$cat = $t["cat"];
$name = $t["name"];
if($tstruc == $dirwidth){
echo "</tr><tr>";
$tstruc = 0;
echo "<td align=\"left\" valign=\"top\"><font face=\"verdana,sans serif,helvetica\" size=\"3\"><b><a href=\"index.php?index=directory.inc&cat=$cat&name=$name&depth=0\">$name</a></b></font>";
$subcat = mysql_unbuffered_query("SELECT * FROM categories WHERE length(cat)='4' && substring(cat,1,2)='$cat' ORDER BY cat");
while($ct = mysql_fetch_array($subcat)){
$scats = $ct["name"];
$dcats = $dcats . $scats . ", " ;
$dcats = trim(substr($dcats, 0, 28)) . trim("...");
if($dcats != "..."){
echo "<br><font face = \"tahoma,sans serif,helvetica\" size=\"1\">" . $dcats . "</font>";
$dcats = "";
echo "</td>";

You can go to the site http://www.icesource.com to see this script in action. This is an intermittent problem so you may not see it at the site, but it does happen there sometimes. If you click on one of the categories on the list there, and to two or three deep, then hit the Home link at the top left of the listings there's a pretty good chance you'll see the problem. I've been trying to figure this out for a long time, and nothing seems to work. Any ideas out there would be greatly appreciated.


Reply via email to