[RESOLVED] Query failing - says it's a permissions thing

dadofgage

I have a page that contains two separate queries from two separate databases outputting data in two separate tables.

The first query runs correctly. There is no problem with it.

When the second query is run, I get an error: mysql_num_rows(): supplied argument is not a valid MySQL result resource .

From what I have found, a common cause of this is the failure to connect to the database.

Here is my php code:

$conn = mysql_connect("localhost","username","password") or die ("<br>".mysql_error());
mysql_select_db("database_name") or die(mysql_error());
$results = mysql_query ("SELECT * FROM tbl ORDER BY date DESC");

$totalcount = mysql_num_rows($results);
$lastdate = date("m/d/y");
$dailycount = 0;

echo "Total:&nbsp;&nbsp;&nbsp;<strong>$totalcount</strong><br><br>\n";

I have an insert query running on another page with the exact same credentials as this query and it runs fine - inserting records as it should.

What am I missing here?

Roger_Ramjet

Your query is failing. If it was failure to connect then your error message would show that
mysql_select_db("database_name") or die(mysql_error());

If it is really as simple as the one you show I doubt its a syntax error. I'd look for mis-spelt table or column names, something like that is causing your query to fail.

dadofgage

It seems you are correct.

I removed the 'ORDER BY' part of the select statement and it worked.

Obviously, I mistyped the field name there.

I appreciate your quick feedback!

Roger_Ramjet

'date' is a mysql reserved word (cos its an sql function) and should not be used for a column name. Sorry should have spotted that the first time.

http://dev.mysql.com/doc/mysql/en/reserved-words.html