Help!

[Dragon Blade]

Hello there MWG! I need your help guys!

I am trying to make all peoples inventory not show the itemtypedrugs along with item.

This is my query

 

$inv =
       mysql_query(
               "SELECT `inv_qty`, `itmsellprice`, `itmid`, `inv_id`,
                `effect1_on`, `effect2_on`, `effect3_on`, `itmname`,
                `weapon`, `armor`, `itmtypename`
                FROM `inventory` AS `iv`
                INNER JOIN `items` AS `i`
                ON `iv`.`inv_itemid` = `i`.`itmid`
                INNER JOIN `itemtypes` AS `it`
                ON `i`.`itmtype` = `it`.`itmtypeid`
                WHERE `iv`.`inv_userid` = {$userid}
                ORDER BY `i`.`itmtype` ASC, `i`.`itmname` ASC");

 

How do I make it not show the item drugs?

[KyleMassacre]

WHERE `iv`.`inv_userid` = {$userid} && it.itmtypeid != <the item type id here>

[Dragon Blade]

Thanks Kyle! That worked perfect!

[Dominion]

Can you please start giving your threads more descriptive names. For example - "inventory query help" rather then simply "Help!".

[Dragon Blade]

Sorry about that, just not good with titles..but Ill try next time.