SQL SYNTAX ERROR, Please Help
Posted: Fri Nov 22, 2002 12:25 pm
The error reads as follows:
" You have an error in your SQL syntax near 'WHERE catid="3"' at line 1 "
Here is the block of code.
<?
$sql = " SELECT * FROM categories WHERE catid=\"$catid\" ";
$result = mysql_db_query($tablename, $sql);
if(mysql_error()!=""){
echo mysql_error();
}
if(!$row = mysql_fetch_array($result)){
echo "Required information has been deleted." ;
} else {
$sql = "UPDATE categories SET ";
$sql = $sql." name=\"".trim(addslashes(stripslashes$name)))."\", "; $sql = $sql." description=\"".trim(addslashes(stripslashes($description)))."\", ";
$sql = $sql." WHERE catid=\"$catid\"";
$result = mysql_db_query($tablename, $sql); if(mysql_error()!="")
{
echo mysql_error();
}
echo "<TABLE cellspacing=0 cellpadding=0 Align=center width='650' border=0> <tr><td align=center height=25><b>Thanks</b></td></tr><tr ><td align=center height=25><b>Your Information have been Successfully added.</b></td></tr></table> ";
}
?>
Thank you for your time,
Matt Urban
" You have an error in your SQL syntax near 'WHERE catid="3"' at line 1 "
Here is the block of code.
<?
$sql = " SELECT * FROM categories WHERE catid=\"$catid\" ";
$result = mysql_db_query($tablename, $sql);
if(mysql_error()!=""){
echo mysql_error();
}
if(!$row = mysql_fetch_array($result)){
echo "Required information has been deleted." ;
} else {
$sql = "UPDATE categories SET ";
$sql = $sql." name=\"".trim(addslashes(stripslashes$name)))."\", "; $sql = $sql." description=\"".trim(addslashes(stripslashes($description)))."\", ";
$sql = $sql." WHERE catid=\"$catid\"";
$result = mysql_db_query($tablename, $sql); if(mysql_error()!="")
{
echo mysql_error();
}
echo "<TABLE cellspacing=0 cellpadding=0 Align=center width='650' border=0> <tr><td align=center height=25><b>Thanks</b></td></tr><tr ><td align=center height=25><b>Your Information have been Successfully added.</b></td></tr></table> ";
}
?>
Thank you for your time,
Matt Urban