Not sure why from the logic i have placed in, it cannot be possible but im sure i've done some silly mistake in the query that i have not spotted so maybe some one here can:
Code: Select all
$Get = mysql_query("SELECT useritem.ItemID,useritem.Quantity FROM useritem
INNER JOIN item ON item.ItemID WHERE item.Trade=1 AND
useritem.UserID='{$_SESSION['Current_User']}'
AND useritem.Quantity>0")
Or die(mysql_error());Useritem table:
ItemId | Quantity | UserID |
---1--- |-----5-----|----1-----|
---2---|-----1-----|----1-----|
Item table
ItemID | Trade |
---2---|-----0-----|
---1---|-----1-----|