[RESOLVED] Trouble with MYSQL Results

daltman1967

$result2=mysql_query("SELECT * FROM orders WHERE ip_address='$Users_IP_address' AND part='$t'");
if(!$result2)
{
...
}
else
{
...
}

For some reason, this query is producing unexpected results. I have no idea why. The table is empty, but it keeps executing the code under the 'else' section. I tried adding one single record with bogus data, but the result is the same. Any ideas? I want this to execute the code under else if both conditions are not true.

dagon

look in the manual for the return value of mysql_query()

daltman1967

I've already done that. With both the empty table and the one line-table with junk data, I'm getting a Resource id #4 in the result. There should be no result unless both elements are true; neither element is true, yet I'm getting a result. It is this which is confusing me.

Any ideas?

bradgrafelman

You didn't read the manual page dagon linked to. Here's a relevant excerpt:

PHP Manual wrote:
For SELECT, SHOW, DESCRIBE, EXPLAIN and other statements returning resultset, mysql_query() returns a resource on success, or FALSE on error.

A result set containing no data is not an error.

A result set containing data that you didn't want is not an error (as far as MySQL is concerned anyway - you asked for it, you got it).

If you want to check if a result set is empty, you should be using something like [man]mysql_num_rows/man.

daltman1967

Ok, I had read the post about mysql results, but hadn't figured out what was happening.

instead of doing it this way:

$result2=mysql_query("SELECT * FROM orders WHERE ip_address='$Users_IP_address' AND part='$t'");
if(!$result2)
{
...
}
else
{
...
}

I needed to do this:

$result2=mysql_query("SELECT * FROM orders WHERE ip_address='$Users_IP_address' AND part='$t'");
$number=mysql_num_rows($result2);
if(!$number)
{
...
}
else
{
...
}

If number is 0... which it will be in this specific case, then it executes the code as I expected. I was keying off the result itself; why the result was producing anything at all, I'm not sure. But I'm glad to see that the solution was easy. Thanks!🙂