[SOLVED] How Can I Do This?...

[Vermillion]

"SELECT * FROM access WHERE user_id = '$id', hash = '$hash' AND level = 8";

 

Like you can see, I want to "SELECT everything from access where the id is $id, the hash is $hash, and the level is 8", but that doesn't work.

How would be the right way to do that?

[corbin]

AND

 

 

where user_id = '$id' AND hash = '$hash'......

[Vermillion]

So I just keep using the AND clause? Okay, thanks al lot .

[Vermillion]

Woops one thing. If I wanted to update the database with multiple different values, would I do something like this:

 

"UPDATE members SET question = '$newquestion'" AND SET answer = '$answer' WHERE id = "$id" AND hash = '$hash'"

 

? Or can I only do:

 

"UPDATE members SET question = '$newquestion'" SET answer = '$answer' WHERE id = "$id" AND hash = '$hash'

[BigTime]

UPDATE members SET question='$newquestion', answer='$answer' WHERE id='$id' AND hash='$hash'