inventory.php Problem

[MrAnthony]

Hey i really need help on this....

What dose this mean its all that show's on my inventory.php

QUERY 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 ')' at line 1

Query was SELECT * FROM items WHERE itmid IN(0, 0, )

 

Any suggestions?

[ddgamedesign]

Mine has this (assuming you use default items):

 

$q=$db->query("SELECT * FROM `items` 
                WHERE `itmid` IN({$ir['equip_primary']},{$ir['equip_secondary']},{$ir['equip_armor']})");

 

Try that out...works fine for my game. The error you posted probably means there's not a properly placed ( or ) somewhere.

[Danny696]

That error doesnt mean what you said SS :/

It means it doesnt have a 3rd value, in this case, equip_armor

[ddgamedesign]

Ah, yes, the blank at the end of the (0, 0, )

Nice spot. :)

[MrAnthony]

So how do i fix that,

Take the Items sql out and then re-add a new one?

[Danny696]

No, post the top 3 lines of your inv

[MrAnthony]

<?php

include_once (DIRNAME(__FILE__) . '/globals.php');

$q=$db->query("SELECT * FROM `items` WHERE `itmid` IN({$ir['equip_primary']},{$ir['equip_secondary']},{$ir['equip_armor']})");

[Danny696]

Hmm, go into PHPMyAdmin, click users, check to see if a colomn is called equip_armor

[MrAnthony]

OMG hahah

I feel stupid now ¬_¬

Theres not

I'll add it now