PHP Exclusion Help

[digatle]

I need to modify my SQL query (seen below) to exclude result. What I need to exclude is:

WHERE `category_id`=\"90".$dept."\"

How do I add a statement to exclude this information?

$menubardep = mysql_query( "SELECT `category_id`, `url`, `description` FROM `spidernet_menubar` WHERE `category_id`=".$blog_id." " );

Digatle

 

[karnaf]

If I understood correctly...

$menubardep = mysql_query( "SELECT `category_id`, `url`, `description` FROM `spidernet_menubar` WHERE (`category_id`=$blog_id AND `category_id`!="90$dept"

is this what you meant???
pay attention that php can replace vars inside strings...

 

[shaddow]

Just add that condition to the select.

$menubardep = mysql_query( &quot;SELECT `category_id`, `url`, `description` FROM `spidernet_menubar` WHERE `category_id`=&quot;.$blog_id.&quot;  AND category_id<>'90&quot;.$dept.&quot;'&quot; );

________
George, M