WHERE

[Anon]

I would like to go through a table and pick out three fields in one row only. This is what I'm looking for, something like this:

SELECT id,email,password FROM tlbname WHERE id='$id' AND firstname='$name' OR lastname='$name'

It doesn't work, I don't even know if there is a OR. I would just like to know how that would be accomplished. It only has to match $name in either firstname or lastname, not both.

Thanks, I hope it makes some sense.

[[deleted]]

Use parenthesis to define what you mean with the AND and OR statements.

Right now the query will match all records:
1. where id=$id AND firstname=$name
2. where lastname=$name.

So you also get all records where lastname=$name but id is not $id.

What you want is:
WHERE id=$id AND (firstname=$name OR lastname=$name)

Further note:
Are you sure you want to match on the id?
ID's are generally used to identify records. They are unique for each record, so if id=$id, then you have already specified one record. If you specify that that record must contain a certain name, then how did you ge the $id in the first place?