[Resolved] two where commands?

[SureFire]

I have a loop that needs to display the data from the author id field but only the rows that have YES in the submit field.

I tried

$query="SELECT * FROM biotemp WHERE ('authid=$authid', 'submit=yes')";

But get a parse error. Any Ideas?

[barand]

try

$query="SELECT * FROM biotemp WHERE (authid='$authid' AND LOWER(submit)='yes')";

[SureFire]

Thank you so much my friend!