MySQL query returns 1 when there is no data?!?

brooky

Dear people,

This has been making me mad for ages so though I would ask if any kind soul could help:

Here is my MySQL query...

$in_list =  "SELECT * FROM shopping WHERE session='$session' AND product='$product' AND product_options='$product_options'";
$result = mysql_query( "$in_list");
$num_rows = mysql_num_rows($result);

When I print this to try and debugg I get:

Query= SELECT * FROM shopping WHERE session='901bece9333239e4d08ee21a9da4993d' AND product='TESAV5S61' AND product_options='6'

No Rows: 1

This is particularly strange because the database table shopping is completely empty?!?

Therefore why does it return 1?

ScubaKing22

Try removing the quotes in the mysql_query() part and see what happens. Thats the only possible error I see in your code.

delfa

that´s too strange!
are you sure you are using the correct connection,database and table?

try to delete that same record and do this:

execute this query:
DELETE * FROM shopping WHERE session='$session' AND product='$product' AND product_options='$product_options';

echo mysql_affected_rows();

if prints 1 then you will know if that record really exists!

drawmack

Did you try using a tool like winsql to run this query directly on the database and see what it returns?

brooky

Thanks guys but still no luck. I've had 4 developers look at this now and it is simply inexplicable. I'm starting to wonder if I've stumbled accross a bug in PHP or MySQL!!

I tested it on IIS with latest php and mysql and Apache with php 4.1.1 etc etc etc....

It is absolute maddness!

I have added every piece of debugging text you possible can and all code seems perfect. Do poltergeists exist in php stuff?

If anyone find the answer I will be beyond overe the moon as the sh*t bag of a bug has bothered me an astonishing 5 days!!!!!!