really need help

[Legaci]

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 inventory WHERE inv_userid=1 AND inv_itemid=

this is all it tells me

is this because of

                  item_remove($ir['userid'], $r['inv_itemid'],  $qty);

or this

 

if(!$_POST['add'])
  {
  $query = array();
  $db->query("SELECT *
           FROM `inventory` mi
           LEFT JOIN `items` i
           ON mi.inv_itemid = i.itmid
           WHERE mi.inv_userid = '".$ir['userid']."'");

  $le = array();
  echo "<table width = '750px' class = 'rounded'><tr><td align = 'center'>
        <table width = '100%'><tr bgcolor = #999999 style = 'font-weight:800;'><td>Item</td><td>Qty</td><td>Add</td>
        </tr>";
  $num=0;

 

or could it be global_func.php

[Bennyh789]

It's not calling the itemid right what's the page this error comes up on?

And post the query that's on the page

[Legaci]

its a mod i am building

[Magictallguy]

_*sigh*

Query starting on line 4 (from the snippet posted above)

$db->query("SELECT `mi`.*, `i`.*
           FROM `inventory` AS `mi`
           LEFT JOIN `items`AS `i`
           ON `mi`.`inv_itemid` = `i`.`itmid`
           WHERE `mi`.`inv_userid` = ".$ir['userid']);

[Djkanna]

Check $r['inv_itemid'] exists before the item_remove call.