[SOLVED] query not showing results

[vinpkl]

hi all

 

this query works fine

$qry_p="select * from product_table where category_name='Digital Cameras' AND  status='Y'";

 

this query also works fine

$qry_p="select * from product_table where category_name='Digital SLR Cameras' and status='Y'";

 

but when i want result of both categories means "Digital cameras" and "Digital SLR Cameras" then no result is found

 

$qry_p="select * from product_table where category_name='Digital Cameras' AND category_name='Digital SLR Cameras' and status='Y'";

 

vineet

[PFMaBiSmAd]

While it is true that AND makes sense if that was a written sentence, it does not make logical sense. Logically, that says I want to match rows WHERE category_name is one value AND category_name is another value at the same time. The condition in the WHERE term must be TRUE for the matching rows.

 

You actually need to use OR. I want to match rows WHERE category_name is one value OR category_name is another value.

[vinpkl]

HI PFMaBiSmAd

 

Thanks for the reply. Its now showing both results.

 

solved.

 

vineet

 

While it is true that AND makes sense if that was a written sentence, it does not make logical sense. Logically, that says I want to match rows WHERE category_name is one value AND category_name is another value at the same time. The condition in the WHERE term must be TRUE for the matching rows.

 

You actually need to use OR. I want to match rows WHERE category_name is one value OR category_name is another value.