MySQL Syntax Error

[drseuss]

I've been trying to figure this error out for a while now.

 

$sql = "select * inventory where pid=".$settings['user']['stats']['id']." AND id=".$itemId;
$result = $db->db_query($sql);
$item = $db->db_fetch_array($result);

 

I use have been doing all of my queries like this. But now I get an error like this.

 

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 'inventory where pid=1 AND id=1' at line 1

 

Please help me figure it out.

[PFMaBiSmAd]

You are missing the FROM keyword.

[drseuss]

Yup... Looks like I do need to go to bed... Thanks a lot.