Syntax error
<?php
$Paramkey_WADArequests = "-1";
if (isset($_GET['key'])) {
$Paramkey_WADArequests = $_GET['key'];
Doing a search set of pages from scratch with blank pages, I am getting this 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 'key, Jewelry_Type, Setting_Style, Head_Type FROM requests WHERE Dealer_ID LIKE '' at line 1
This is the request//
mysql_select_db($database_Ben, $Ben);
$query_WADArequests = sprintf("SELECT key, Jewelry_Type, Setting_Style, Head_Type, Prong_Style, Gallery, Shank_Metal, Shank_KaratsW, Shank_KaratsY, Shank_Style, Inside_Shank, Shank_Height, Shank_Width, Edge_Finish, Finger_Size_Main, Finger_Size_half, Gender, Main_Diamond_Shape, MD_Carat, MD_MM_Size, Crown_HeightMM, MD_Color, MD_Clarity, Shoulder_DIamonds1_Shape, SD1_Quantity, SD1_Carat, SD1_MM_Size, SD1_Color, SD1_Clarity, Shoulder_Diamonds2_Shape, SD2_Quantity, SD2_Carat, SD2_MM_Size, SD2_Color, SD2_Clarity, Other_Diamonds_Shape, OD_Quantity, OD_Carat, OD_MM_Size, OD_Color, OD_Clarity, First_Name, Last_Name, Email, Comment, Phone, Call_Time, Address, City, State, Country, Zip FROM requests WHERE key = %s", GetSQLValueString($Paramkey_WADArequests, "int"));
$WADArequests = mysql_query($query_WADArequests, $Bendannie) or die(mysql_error());
$row_WADArequests = mysql_fetch_assoc($WADArequests);
$totalRows_WADArequests = mysql_num_rows($WADArequests);
?>