is this possible?

2 'wheres' in mysql statement

[surrealillusions]

Take this statemet (from my other post about echoing when empty etc..)

$data = mysql_query ("SELECT * FROM database WHERE animal='hamster' ORDER BY id DESC")

Can you add 2 where statements in there?

such as

$data = mysql_query ("SELECT * FROM database WHERE animal='hamster' WHERE animal='giraffe' ORDER BY id DESC")

Is that possible?

[Staffa]

$data = mysql_query ("SELECT * FROM database WHERE animal='hamster' WHERE animal='giraffe' ORDER BY id DESC")

You could do :

$data = mysql_query ("SELECT * FROM database WHERE animal='hamster' AND animal='giraffe' ORDER BY id DESC")

[LifeinAsia]

Um, unless there is such a beast as "hamstiraffe" or "giramster," I suggest the following instead:
SELECT *
FROM database
WHERE animal='hamster' OR animal='giraffe'
ORDER BY id DESC

[edited by: LifeinAsia at 5:21 pm (utc) on May 15, 2008]

[surrealillusions]

thanks guys

the 'and' worked for what i need, but its nice to know that there is an 'or' option too.

What other options are there that can go in there?

:)

[LifeinAsia]

NOT (as in "OR NOT" and "AND NOT")

[chorny]

surrealillusions, read mysql documentation - you can't write program without knowing language.

[surrealillusions]

I do read it, or at least try to read it, and php tutorials etc.. but sometimes i cant find the simple stuff..

:)