update and where

[Beers]

Hi I want to do this:

$query = "UPDATE user SET auth='$auth' WHERE email='$email'";

But with two WHERE conditions

WHERE email='$email' AND uni='$uni'

is AND the correct statement?

Cheers!

Simon.

[bpat1434]

Yes... yes it is...

How mySQL optimizes WHERE clauses

~Brett