Page 1 of 1

mysql_fetch_array() error?

Posted: Thu Aug 25, 2005 5:12 pm
by Jeefo
I have this script but every time it gives me this:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /drive2/fpgshttpd/jeefo/comments.php on line 39

Line 39 in the script is:

Code: Select all

$html[] = 'Posted by: ' . $a['author'] . ' on ' . date('M j, Y :: h:ia', $a['time']) . '<br />' . $a['comments'];
What's wrong with it? 8O

Posted: Thu Aug 25, 2005 5:20 pm
by feyd
that's not line 39 ;)

you likely have an error in you SQL query syntax. Post more code, echo out the query string you send to MySQL making sure it's syntacticaly correct.