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