MySQL Conventions?
Posted
by Moe
on Stack Overflow
See other posts from Stack Overflow
or by Moe
Published on 2010-06-06T10:36:37Z
Indexed on
2010/06/06
10:42 UTC
Read the original article
Hit count: 268
Hi There,
I just moved my website to a new server (Shared to VPS)
I expected errors, and the only error that is really puzzling me is this SQL statement.
echo mysql_query("SELECT COUNT(*) FROM users_online_now")
This returns nothing! And if I try the mysql_num_rows
, it returns
mysql_num_rows(): supplied argument is not a valid MySQL result resource..
If I query another table though eg:
echo mysql_query("SELECT COUNT(*) FROM users")
It works fine.
I'm guessing it's something to do with the naming of the table? It worked fine on my previous host, is there some setting I should modify?
© Stack Overflow or respective owner