i want an sql statment that select from table where prefer has the word auction or cash

i tried:
$sql="select * from products where prefer like '%cash%' ";

and it worked biut i tried:
$sql="select * from products where prefer like '%cash%'  or prefer like '%auction%'  ";

but didn't work !!!



Rehab M.Shouman

------------------------------------------------------------
------------------------------------------------------------


---------------------------------------------------------------------
Express yourself with a super cool email address from BigMailBox.com.
Hundreds of choices. It's free!
http://www.bigmailbox.com
---------------------------------------------------------------------

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to