How can i exclude a styleid from this?
 

$allstyles=$DB_site->query("SELECT style.title, user.styleid, COUNT(*) AS count FROM user LEFT JOIN style USING (styleid) WHERE style.styleid IS NOT NULL AND style.userselect=1 GROUP BY user.styleid");
$dropdownbits='';
while ($thisstyle=$DB_site->fetch_array($allstyles)) {
if ($styleid==$thisstyle[styleid]) {
$stylesel='selected';
} else {
$stylesel='';
}
eval("\$dropdownbits .= \"".gettemplate('forumhome_dropdownbit')."\";") ;
}

I want to make it so styleid=X is not shown in the menu, no point posting in the appropriate thread as firefly is far too busy to reply and normally no one replies...it's just a quick question for someone with experience in PHP/SQL.

SO is the <> sign in sql the equivalent of != in PHP?

- miSt

<> and != is equivalent in php and in sql, so you can also use <> in php and also != in sql :)

Oh i see - that's quite cool then *one to remember* ;)

Thanks

- miSt

Thanks Xenon!

you're both welcome :)