SQL statement question

[boblan66]

I would like to know if I'm thinking in the right direction?

 

I recently was looking at sample code that gave this as an example:

 

$sql_email_check = mysql_query("SELECT email_address FROM users WHERE email_address='$email_address'");
$sql_username_check = mysql_query("SELECT username FROM users WHERE username='$username'");

 

If I learned correctly while reading about SQL, the two lines of code could have been one. Such as:

 

$sql_email_check = mysql_query("SELECT email_address FROM users WHERE email_address='$email_address' AND username='$username'");

 

Is this correct?

 

[Maq]

Sure, but what exactly are you trying to do?

[boblan66]

I am creating a membership site for my wife's high school class. This code was part of  an example for checking if the username and password was valid.

[Maq]

I am creating a membership site for my wife's high school class. This code was part of  an example for checking if the username and password was valid.

 

The validity of usernames, emails, and passwords should be checked server-side (PHP).

 

You also may want to use an OR rather than an AND because you would want to check if either the email or username already exists.

[boblan66]

Thank you for your quick response. You validified my thinking.

[Maq]

Thank you for your quick response. You validified my thinking.

 

No problem.  If you have questions regarding validation be sure to start a new thread.