DaniWeb Forum Index > Web Development > PHP

how do i do three WHERE clauses with php (mysql)

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Apr 2009

Posts: 290

Reputation: SKANK!!!!! is an unknown quantity at this point

Solved Threads: 2

SKANK!!!!! SKANK!!!!! is offline

Offline

Posting Whiz in Training

how do i do three WHERE clauses with php (mysql)

Jun 12th, 2009

this code isnt workin:

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
$newer = mysql_query("DELETE FROM messages WHERE id = '$rawr', user = '$rew', read = '$roll'");
$newer = mysql_query("DELETE FROM messages WHERE id = '$rawr', user = '$rew', read = '$roll'");

this code works:

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
$newer = mysql_query("DELETE FROM messages WHERE id = '$rawr' AND user = '$rew'");
$newer = mysql_query("DELETE FROM messages WHERE id = '$rawr' AND user = '$rew'");

the variable is the same that is included in the first, so its not the variable. i think i dont know how to have three of them cause i know that for two i can use the AND instead of commas.
please help i googled it and couldnt figure it out

•

Join Date: Oct 2006

Posts: 48

Reputation: yilmazhuseyin is an unknown quantity at this point

Solved Threads: 5

yilmazhuseyin yilmazhuseyin is offline

Offline

Light Poster

Re: how do i do three WHERE clauses with php (mysql)

Jun 12th, 2009

it is not working becasue you are using , instead of and

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
$newer = mysql_query("DELETE FROM messages WHERE id = '$rawr' AND user = '$rew' AND read = '$roll'");
$newer = mysql_query("DELETE FROM messages WHERE id = '$rawr' AND user = '$rew' AND read = '$roll'");

this should work

•

Join Date: Apr 2009

Posts: 290

Reputation: SKANK!!!!! is an unknown quantity at this point

Solved Threads: 2

SKANK!!!!! SKANK!!!!! is offline

Offline

Posting Whiz in Training

Re: how do i do three WHERE clauses with php (mysql)

Jun 15th, 2009

so i can use more than two ands? can i use like 5 ands?

•

Join Date: May 2007

Posts: 4,506

Reputation: Ezzaral has a brilliant future

Solved Threads: 521

Ezzaral

Offline

Industrious Poster

Re: how do i do three WHERE clauses with php (mysql)

Jun 15th, 2009

You can use as many ANDs and ORs as you like, with as many parenthesis as you like to create as many logical sub-groupings as you like:

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
a AND b AND (c OR (d AND e) OR (f AND g)) ...
a AND b AND (c OR (d AND e) OR (f AND g)) ...

but be aware that at some point you cross a line where you should probably re-examine your join criteria and ask yourself why you're having to specify so much in a WHERE clause.