count function

[New_Coder]

Hi,
How to count function for two queries (where)! Example :

$query = "SELECT COUNT(*) FROM products WHERE id=5 and approved=YES"; //Count Not Work With WHERE id=5 and approved=YES

Thanks

[johanafm]

Count does indeed work in the given example, but assuming that the field id is a primary key, there can be 0 or 1 rows with id=5, and if there is a row where id = 5, there can be 0 or 1 rows with id=5 and approved=YES.
However, when you write approved=YES, you most likely mean approved='YES'

[New_Coder]

Yea, i know. Can you tell me with any example code ?

[johanafm]

approved='YES'