 |  |  |  |  |  |  |  |
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource
Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
 |
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource
0
#1 Jan 13th, 2006
Hey there, im not very great at php and im wondering how i could fix this error
This is line 328
$num1=mysql ect ect is line 328 any help is much apreicated.
PHP Syntax (Toggle Plain Text)
This is line 328
PHP Syntax (Toggle Plain Text)
$num1=mysql ect ect is line 328 any help is much apreicated.
Re: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource
0
#2 Jan 13th, 2006
You're mysql query isnt a valid one, first off, at the end of querys you should get use to doing this:
mysql_query(blah) or die(mysql_error());
That will tell you if the query doesn't work.
Really, without seeing your table there isnt much that I can tell you to fix, just check all your names and do what I said above. Also, it doesn't hurt to echo $query2 to find out what it says inside that, if it's not a valid pointer your sql will fail. Try messing around with what I said a little and if it still doesn''t help, come back.
Oh also, at the top of your put this:
error_reporting ( E_ALL);
That will help in deciding on what the errors specifically are.
mysql_query(blah) or die(mysql_error());
That will tell you if the query doesn't work.
Really, without seeing your table there isnt much that I can tell you to fix, just check all your names and do what I said above. Also, it doesn't hurt to echo $query2 to find out what it says inside that, if it's not a valid pointer your sql will fail. Try messing around with what I said a little and if it still doesn''t help, come back.
Oh also, at the top of your put this:
error_reporting ( E_ALL);
That will help in deciding on what the errors specifically are.
Re: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource
0
#3 Jan 13th, 2006
I got a different error when i took at $div and it said syntax error in the sql
Re: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource
0
#4 Jan 13th, 2006
What's the error say specifically?
Re: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource
0
#5 Jan 15th, 2006
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-30, 30' at line 1
|
Similar Threads
- Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource (PHP)
- Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in (PHP)
Other Threads in the PHP Forum
- Previous Thread: I Need Help Please. Adding PHP Code To My Site.
- Next Thread: Passing Information Between pages
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest PHP Posts
- Today's Posts
- Unanswered Threads
.htaccess alexa apache api array beginner beneath binary broadband broken cakephp checkbox class cms code convert cron curl database date display dynamic echo email emptydisplayvalue encode error fcc file files folder form forms function functions google howtowriteathesis href htaccess html image images include insert ip javascript joomla key keywords limit link login mail mail() memberships menu mlm multiple multipletables mysql mysql_real_escape_string network oop open passwords paypal pdf php provider query radio random redirect remote rss script search securephp server sessions smtp source space sql strip_tags syntax system table template tutorial update upload url user validator variable video voteup web youtube
