View Single Post
Old 02-17-2008, 10:30 PM   #1 (permalink)
sarmenhb
The Addict
 
sarmenhb's Avatar
 
Join Date: Jan 2008
Location: los angeles
Posts: 309
Thanks: 44
sarmenhb is on a distinguished road
Default i keep getting unknown error by mysql

anyone see anything wrong in this query?

this is the error im getting:

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( null, 'date', '127.0.0.1', 'k', 'Open', 'Bug', 'Urgent'' at line 1


Code:
$save = mysql_query("INSERT INTO tbl_issues(id,date,ip,domain,status,type,priority,module,title,path,desc) VALUES(

null,
'date', 
'$ip', 
'".$_POST['txt_domain']."',
'".$_POST['drop_status']."',
'".$_POST['drop_type']."',
'".$_POST['drop_priority']."',
'".$_POST['drop_module']."',
'".$_POST['txt_title']."',
'".$_POST['txt_path']."'
'".$_POST['txt_desc']."'") or die(mysql_error());
__________________
no signature set
sarmenhb is offline  
Reply With Quote