[RESOLVED] Ignoring rows with certain attributes

[kona72]

:bemused: Hi Again,

I have this bit of code.

$results = mysql_query("SELECT * FROM `Active Members` WHERE `Rostar` =1 WHERE `MembershipStatus`=`Active` ORDER BY `LastName` ASC LIMIT $current_record, $limit");

The output is to display only rows that have a 1 in the Rostar column and have Active in the MembershipStatus column. I keed getting this error....

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE MembershipStatus=Active ORDER BY LastName' at line

Any ideas??

Thanks so much!!!

[devinemke]

you have 2 WHERE's...that's a no-no.

[goldlikesnow]

replace the backtiks (`) arround your values for quoutes (')

[kona72]

devinemke wrote:

you have 2 WHERE's...that's a no-no.

Is there anything else I can do in place of this??

Thanks....

[devinemke]

kona72 wrote:

Is there anything else I can do in place of this??

use the keyword "AND"

[kona72]

Great!!

Thanks Guys!!

I don't know what I would do without this board!!!!!