[RESOLVED] 2nd record set error

[shifty18]

I am having a really anoying problem I get the 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 found on line: 14

the code it is refering to is my 2nd record set, line 14 is the 3rd line down

mysql_select_db($database_AmmoBox, $AmmoBox);
$query_CustomerDetails = "SELECT user_email FROM phpbb_users WHERE user_id = $id";
$CustomerDetails = mysql_query($query_CustomerDetails, $AmmoBox) or die(mysql_error() . ' found on line: ' . __LINE__);
$row_CustomerDetails = mysql_fetch_assoc($CustomerDetails);
$totalRows_CustomerDetails = mysql_num_rows($CustomerDetails);

This record set was produced by dreamweaver however so iam sure there is no spelling or DB errors and i have a record set just above it that works fine

Anyone know why i get this problem

Thanks
Chris

[Lars_Berg]

Echoing the actual query may help in spotting the error

$CustomerDetails = mysql_query($query_CustomerDetails, $AmmoBox) or die(mysql_error() . 
' found on line: ' . __LINE__ . " when executing " . 
$query_CustomerDetails );

Presumably $id is undefined.

[shifty18]

ahh yeah, id has no value, even tho i set it a few lines up, ok thanks ill look into it 🙂