Combining and & OR in sql

[jeff5656]

I want to have AND and OR but the following query gave me a syntac error:

 

$q = "select * from todo where and username = '$username' AND (mrn = '$mrn'  OR lname = '$lname')";
$results = mysql_query ($q) or die (mysql_error());

I looked on W3 and it looked just lie above so not sure where th syntax error is.

[trq]

You have an extra 'and' after your first 'where'.

[objnoob]

You should not have an 'AND' operand directly after your WHERE clause.

 

try

 

$q = "select * from todo where username = '$username' AND (mrn = '$mrn'  OR lname = '$lname')";

[jeff5656]

DUH!  Thanks - didnt see that :-)