Item Market (Don't want the Items Drugs Showing)

[Dragon Blade]

Hey there MWG once again! I need your help guys,

Well in the itemmarket. I don't want the itemtypeid 9 to be shown there.

 

$q=mysql_query("SELECT im.*, i.*, u.*,it.* FROM itemmarket im LEFT JOIN items i ON im.imITEM=i.itmid LEFT JOIN users u ON u.userid=im.imADDER LEFT JOIN itemtypes it ON i.itmtype=it.itmtypeid ORDER BY i.itmtype, i.itmname ASC LIMIT $st, $app");

 

Any help will be great!

[Script47]

Just a suggestion, maybe an array which has all the item id's then just add them to the query or something.

[KyleMassacre]

all you really need is just a WHERE statement like where it.itmtypeid !=9

[rockwood]

KyleMassacre's " !=" or you can use of "<>" bcz both having same mean not equal to

$q=mysql_query("SELECT im.*, i.*, u.*,it.* FROM itemmarket im LEFT JOIN items i ON im.imITEM=i.itmid LEFT JOIN users u ON u.userid=im.imADDER AND i.itemtypeid <> "item id goes here");

[Dragon Blade]

Thanks RockWood, didn't work unfortunately.

@KyleMassacre - I tried that but the only problem is, it doesn't show the price or the item. Just the row with my name on it.

[KyleMassacre]

there should he no reason it wouldn't work.

[Dragon Blade]

Okay I have fixed this, thanks all!