MySQL Conventions?
- by Moe
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?