2 where clauses in mysql query

[Flufferman]

Hi,

Is it possible to put 2 where closes in your mysql select query. I need it because some people appear to be available twice, so I need to add from which team I want the information, so I need a where for the name and a where for team.

I tried with and but that doesn't seem to work. Does anyone know a workaround?

Grtz

[kireol]

use where once. separate with "and"

select * from teammembers where name = 'jack handy' and team = 'purple cobras'

[click here]

use any mysql class to make it easy

[vaultdweller123]

use the 'and' keyword to add more conditional statements

[daryll1]

Yeah 'and' will work e.g.

'SELECT * FROM team_members WHERE name = " ' . $variable . ' " AND team = " ' . $second_variable . ' "';