not a valid MySQL result resource

From: Date: Thu, 26 Oct 2000 17:01:35 +0000
Subject: not a valid MySQL result resource
Groups: php.general 
Request: Send a blank email to php-general+get-22171@lists.php.net to get a copy of this message
Hi All, I am getting tow error for a piece of code. can someone look this over and see where I screwed up. Warning: Supplied argument is not a valid MySQL result resource in g:\program files\apache group\apache\htdocs\next.php on line 23 /td> Warning: Supplied argument is not a valid MySQL result resource in g:\program files\apache group\apache\htdocs\next.php on line 33 PREV NEXT while ($data=mysql_fetch_array($result)){ <------------------line 23 echo "<table border=1>\n"; echo "<tr><td>ID</td><td>Accepted</td><td>Username</td><td>Password</td><td>Email</td></tr>\n"; } do { printf("<tr><td>%s</td><td>%s</td><td>%s</td><td>%s<td>/td><td>%s</tr>\n",$myrow["id"],$myrow["accepted"],$myrow["username"],$myrow["password"],$myrow["email"]); } while($myrow = mysql_fetch_array($result)); <---------------line 33 echo "</table>\n"; thanks Gary -- The sad thing about artificial intelligence is that it lacks artifice and therefore intelligence.Jean Baudrillard (1929), French semiologist.

« previous php.general (#22171) next »