MySQL Error : Query Error
Error Number: 1064 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', 10, 12, 'on')' at line 1
代码如下:
$tbl_data[] = "INSERT INTO $POLLTBL[poll_config] (config_id,base_gif,lang,title,vote_button,result_text,total_text,voted,send_com,img_height,img_length,table_width,bgcolor_tab,bgcolor_fr,font_face, font_color,type,check_ip,lock_timeout,time_offset,entry_pp,poll_version,base_url,result_order,def_options,polls_pp,captcha) VALUES(1, '$image_url', 'gb2312.php', 'Advanced Poll', 'Vote', 'View results', 'Total votes', 'You have already voted!', 'Send comment', 10, 42, '170', '#FFFFFF', '#666699', 'Verdana, Arial, Helvetica, sans-serif', '#000000', 'percent', 0, 2, '0', 5, '$version', '$base_url', 'desc', 10, 12, '$captcha')";
Error Number: 1064 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', 10, 12, 'on')' at line 1
代码如下:
$tbl_data[] = "INSERT INTO $POLLTBL[poll_config] (config_id,base_gif,lang,title,vote_button,result_text,total_text,voted,send_com,img_height,img_length,table_width,bgcolor_tab,bgcolor_fr,font_face, font_color,type,check_ip,lock_timeout,time_offset,entry_pp,poll_version,base_url,result_order,def_options,polls_pp,captcha) VALUES(1, '$image_url', 'gb2312.php', 'Advanced Poll', 'Vote', 'View results', 'Total votes', 'You have already voted!', 'Send comment', 10, 42, '170', '#FFFFFF', '#666699', 'Verdana, Arial, Helvetica, sans-serif', '#000000', 'percent', 0, 2, '0', 5, '$version', '$base_url', 'desc', 10, 12, '$captcha')";
config_id,
base_gif,
lang,
title,
vote_button,
result_text,
total_text,
voted,
send_com,
img_height,
img_length,
table_width,
bgcolor_tab,
bgcolor_fr,
font_face,
font_color,
type,
check_ip,
lock_timeout,
time_offset,
entry_pp,
poll_version,
base_url,
result_order,
def_options,
polls_pp,
captcha值域列表 30 个
1,
'$image_url',
'gb2312.php',
'Advanced Poll',
'Vote',
'View results',
'Total votes',
'You have already voted!',
'Send comment',
10,
42,
'170',
'#FFFFFF',
'#666699',
'Verdana,
Arial,
Helvetica,
sans-serif',
'#000000',
'percent',
0,
2,
'0',
5,
'$version',
'$base_url',
'desc',
10,
12,
'$captcha'