Re: Not a valid mysql result resource???

Oops...I found it. I forgot to include the config file which specifies $mysql_table. Thanks!!! Tyler On Tue, 8 Aug 2000, Chris Murley wrote: > Date: Tue, 8 Aug 2000 09:46:51 -0500 (CDT) > To: Tyler Longren <tyler.longren@midiowa.net> > From: Chris Murley <murley@appindex.net> > Subject: Re: [PHP] 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 > > > > > -- > 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 >