$conn->Execute("Insert Into User_Items
Values(".$Cart->Fields['Cart_Item_ID']->Value.",'".$groupD->Fields['Group_Name']->Value."','".$cdD->Fields['Cd_Title']->Value."', ".$cdD->Fields['Cd_Price']->Value.", ".$qty2.", ".$cdD->Fields['Cd_Special']->Value.")");
Its telling me i have a syntax errors if anyone has any idea whats wrong or any pointers on how i could fix it it would be appreciated.
Error with my php database code
Moderator: General Moderators
- aceconcepts
- DevNet Resident
- Posts: 1424
- Joined: Mon Feb 06, 2006 11:26 am
- Location: London
Please tryand post the output.
Code: Select all
$query = "Insert Into
User_Items
Values(
".$Cart->Fields['Cart_Item_ID']->Value.",
'".$groupD->Fields['Group_Name']->Value."',
'".$cdD->Fields['Cd_Title']->Value."',
".$cdD->Fields['Cd_Price']->Value.",
".$qty2.",
".$cdD->Fields['Cd_Special']->Value."
)";
echo '<div>Debug: ', htmlentities($query), "</div>\n";
$conn->Execute($query);