PHP 5 Compile problem?

I upgraded my system to mysq 5 and PHP v5.2.1

I now have a problem when fetching records in a where query.

I have many existing site that where all working on my system pre upgrade

Using PHP pages.

This type of query comes back with data from the database

SELECT * FROM store group by subcat_id having count(subcat_id)>=1 ORDER BY subcat_id ASC");

This type of query comes back with no data and no errors?

SELECT * FROM store where cat_id='$cat_id';

PHP.ini problem?

Please help

Can you do a little debugging. First try to do

SELECT * FROM store WHERE cat_id = '5'

Where 5 is a value that exists in the database

If that works then it is something with PHP, if it doesn't work it have something to do with the database.

If it is PHP, can you echo the finished query in the second example to see if the variable is replaced.

Thanks Piranha

SELECT * FROM store WHERE cat_id = '5'

Yes this works

See php ini

If the variables are replaced and it works without variables I have no idea what the problem is, someone else might be able to help you out further.

How is $cat_id defined in your code?