can't find sql error =(
Posted: Fri Feb 23, 2007 6:37 pm
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 'desc ) VALUES ( 'Test', 'testers', 'description for test' ' at line 4
anyone know where its at?
anyone know where its at?
Code: Select all
$cat = $_POST['select'];
$name = $_POST['textForumName'];
$desc = $_POST['textForumDesc'];
//get last forum order
$result = mysql_query("SELECT forum_order FROM forums WHERE cat='$cat' ORDER BY forum_order DESC");
$forum_info = mysql_fetch_object($result);
mysql_query("INSERT INTO forums (
cat,
name,
desc
)
VALUES (
'$cat',
'$name',
'$desc'
)") or die(mysql_error());