Php-mysql

Discussion in 'PHP' started by masterofzoo, Sep 28, 2011.

0
  1. #1
    can I select from database according to multiple conditions, if so, how is that?
    select * from database wher a= 15,b=30,c>6,..ect
     
    Solved! View solution.
    Last edited: Sep 28, 2011
    masterofzoo, Sep 28, 2011 IP
  2. fairuz.ismail

    fairuz.ismail Peon

    Messages:
    232
    Likes Received:
    10
    Best Answers:
    0
    Trophy Points:
    0
    #2
    You can use AND or OR in the SQL statement. Example : SELECT * FROM table WHERE col1 = 10 AND col2 = 200
     
    fairuz.ismail, Sep 28, 2011 IP
    Raj Kumar likes this.
  3. #3
    You can use AND in the SQL statement.
    Example : SELECT * FROM table WHERE a = 15 AND b = 30 AND c > 6


    Sheetal
     
    SheetalCreation, Sep 28, 2011 IP