"INSERT INTO user_items VALUES('{$_SESSIONї'id']}', '(SELECT itemID FROM item WHERE itemName=$name)')"
Its inside a function that takes $name as a parameter. But for some reason, the SELECT keeps returning 0.
I'm pretty sure that means what im doing is wrong, so waht is the correct way?
$sql = "INSERT INTO user_items VALUES('{$_SESSION['id']}', '(SELECT itemID FROM item WHERE itemName=$name)')";
echo $sql;
mysql_query($sql) or die(mysql_error());
already tried it keep getting:
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 'SELECT itemID FROM item WHERE itemName='Pillow'))
INSERT INTO user_items (userID,itemID) VALUES('24', (SELECT itemID FROM item WHERE itemName='Pillow'))
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 'SELECT itemID FROM item WHERE itemName='Pillow'))'