PHP MySQL quck question please help.

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • l!m!t
    New Member
    • May 2006
    • 5

    PHP MySQL quck question please help.

    Hello,

    I am new to PHP and MySQL, but am learning quickly. Hopefully somebody can help me real quick.

    I have an SQL query that I want to send a couple of number to. The numbers are 0 and 3 any idea how I can do this ? I will paste what I have below.

    $find= "where c.customers_las tname like '%" . $keywords . "%' or c.customers_fir stname like '%" . $keywords . "%' or c.customers_ema il_address like '%" . $keywords . "' and member_level = '0'"; //<---- I want member_level to include 0 and 2.in its search.

    Thanks for any help!
  • ronverdonk
    Recognized Expert Specialist
    • Jul 2006
    • 4259

    #2
    Not quite clear, but are you looking for an criteria where the member_level must be either 0, 1 or 2?
    [PHP]AND (member_level = '0' OR member_level='1 ' OR member_level='2 ')[/PHP]

    Ronald :cool:

    Comment

    Working...