Re: Not a valid mysql result resource???

Your mysql select statement is wring, try printing it out.. ie: > 7. $check = mysql_query("SELECT * FROM $mysql_table WHERE email = > '$email'"); echo "$mysql_table"; are you sure thats is being set? I only get that error when i make a syntax error in my mysql statements Chris On Tue, 8 Aug 2000, Tyler Longren wrote: > Hello everybody, > > I've got a question. I get this error for some reason: > > > Warning: Supplied argument is not a valid MySQL result resource in > /usr/local/apache/htdocs/eds/signform3.php on line 8 > > here's the lines: > > 6. $db = mysql_select_db("$mysql_db", $connection); > 8. $rowcheck = mysql_num_rows($check); > 9. if ($rowcheck == "0") { > 10. print "That combination of name and email wasn't found in our > databases. Are 11. you sure you typed it in correctly?"; } > > > Anybody know why this happens? I used almost the EXACT same thing on a > previous project and i didn't have this problem there. > > Thanks! > > Tyler Longren > http://foo-bar.net > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net >