>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:
First, i'd place an... or die (mysql_error()) after your mysql call. so
you can see what mysql is complaining about. basically your sql is
failing. I also like to split the first two items, when debegging, to see
what the actual query was. i.e.
<psedocode>
$qry = "SELECT * FROM categories WHERE length(cat)='2'";
$s = mysql_query($qry) or die (mysql_error() . "\n"<br>" . $qry .
"\n<br>");
<psedocode>
The only time i saw the error on your page the 'cat' GET variable was
defined as 0. Is this really a static query like below, or is it based on
what is passed to the page in the query string? The URL when it died...
http://www.icesource.com/index.php?depth=0&cat=0&index=main.inc, which to
me looks like a bad querystring, but may indeed be valid values.
If that doesn't lend itself to any useful information, try var_dump($t); in
your while loop, to see what has been processed and what is failing.
HTH
Jeff
>$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>";
> ++$tstruc;
>}
>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.
>Nick
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
