New server - suddenly argument is not a valid MySQL result

[Jon Norris]

Hi and thanks for even reading this far!
My database driven book store works fine on my hosts server. I have just moved it to a new but very similar server and am getting >>Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/anita/public_html/cat-ancient-history.php on line 7<<
[/color]Line 7 says >>$eg_count = mysql_num_rows(mysql_query("SELECT * FROM books  WHERE keywords LIKE '%ancient%' AND keywords LIKE '%history%' AND status <> 'sold' ORDER BY author ", $eg_objConn1)); <<
[/color]The >>SELECT * FROM....etc<< works fine as a query on its own in phpMyAdmin so it seems to be the num_rows function.
[/color]I split the statement into a query and then asked num_count to operate on that result rather than all in one line - but no luck.
[/color]Both servers are pretty identical - one runs MySQL Server version: 5.0.90-community and the new one runs 5.91
[/size]I believe they are both running PHP5 though not sure through cpanel where to find this out.
[/size]
[/size]Help, please!
[/color]

[phphelp]

Try to debug to see MySQL error message. Do this:

PHP Code: [Select]

mysql_query("SELECT * FROM books  WHERE keywords LIKE '%ancient%' AND keywords LIKE '%history%' AND status <> 'sold' ORDER BY author ", $eg_objConn1);
echo mysql_error();

[jnorris235]

Read books and all - didn't know that statement!
Thank you - it gave the response:
No database selected
[/color]
[/color][font=times, 'times new roman', georgia, verdana, serif]Which prompted me to check everything. The second time I added the user I forgot to ADD to database in the rush.[/font][font=times, 'times new roman', georgia, verdana, serif]I feel very shamed and sorry I wasted peoples time. Your help did it though - so thanks![/font]