Simple MYSQL/PHP Query Question, Can you use more then one Where?

[DDRcasey]

Basically the subject ask it all. Are you able to use more then on WHERE in a MYSQL query that you can have in a PHP file. What i need to do is like, have an sql where a few fields = something, and im just asking if you can use more then one where, and how. would i put. SELECT FROM table WHERE id='1' WHERE name='Johhn' or would i use SELECT FROM table WHERE id='1' AND WHERE name='John'? Thanks in advanced.

[mikawhat]

don't think so...

[bodzan]

...it is obsolete...

SELECT * FROM table WHERE id='1' WHERE name='Johhn' or would i use SELECT * FROM table WHERE id='1' AND name='John'

[Drakla]

Only one WHERE per query / subquery and use ANDs and ORs for multiple conditions, group with brackets if necessary. When you come up again more complex joins you might have USING clauses, and you can use more than one of them, but cross that when you come to it.