I have a nice query which I created a dump for in my PHPScript. When I try to re-run it in PHP it produces a MySQL error BUT when I revert to phpMyAdmin and run the query (Minus the two variables) it works 100% fine. If anyone has any ideas it would be appreciated.
mysql_query("
INSERT INTO mtl_config (id,filename,status,status_reason,banned_ip,banned_email,enable_gzip,header_show,header_cach,header_nt,cookie_name,cookie_time,cookie_path,cookie_domain,cookie_secure,copyright_name,date_long,date_short,date_mid,date_adjust2,date_adjust,pageno_adv,rows_fill_up,rows_total,rows_banner,banner_ex,banner_size,banner_path,banner_http,banner_upload,banner_link,banner_max,list_order,list_updown,list_hide,hits_show,hits_value,enable_comments,enable_votes,enable_votes_record,enable_out,enable_out_record,enable_hits,enable_hits_record,enable_rating,enable_register,enable_userhide,enable_site_moment,enable_categories,enable_webring,min_letters,mtl_name,mtl_url,mtl_owner_name,mtl_owner_email,skin_choice,skin_selectable,lang_names,lang_choice,lang_selectable,sep_top,sep_regular,debug_1,debug_2,debug_3,max_load,reg_check_mail,reg_accept,reg_email,reg_email_info,reg_admin_newuser,email_sig,vote_code,rate_code,ring_code,vote_gateway,vote_allow,vote_codes,macro_lang,macro_skin,update_votes,update_votes_time,update_votes_last,update_votesall,update_votesall_time,update_votesall_last,update_out,update_out_time,update_out_last,update_outall,update_outall_time,update_outall_last,update_hits,update_hits_time,update_hits_last,update_hitsall,update_hitsall_time,update_hitsall_last,update_rating,update_rating_time,update_rating_last,update_ratingall,update_ratingall_time,update_ratingall_last,update_fromlast,session_time,update_votes_time_acp,update_out_time_acp,update_hits_time_acp,update_rating_time_acp,update_votesall_time_acp,update_outall_time_acp,update_hitsall_time_acp,update_ratingall_time_acp) VALUES ('1','index.php','1','List is currently off','','','1','0','0','0','mtl_','','','','0','My Site','l dS F Y, g:iA','d-m-y','d-m-y, g:iA','0','0','1','1','25','10','gif,jpg,png','100','','http://www.yourdomain.com/mtl/banners/','1','1','480x60','sum(40,20,20,20)','1','','1','1359','1','1','1','1','1','1','1','1','1','1','1:1043133043:3','1','1','4','{$mtl->input['name']}','{$mtl->input['url']}','Your Name','yourname@youremail.com','1','1','1:English','1','1','10','0','1','1','1','25','0','0','0','0','0','Thankyou, my boards','<a href=\\\'%url%\\\'>Vote for my site!</a>','<form method=\\\'post\\\' action=\\\'%url%\\\'>\n<input type=\\\'hidden\\\' name=\\\'redirect\\\' value=\\\'URLHERE\\\'>\n<input type=\\\'hidden\\\' name=\\\'id\\\' value=\\\'%id%\\\'>\n<input type=\\\'hidden\\\' name=\\\'act\\\' value=\\\'misc\\\'>
<input type=\\\'hidden\\\' name=\\\'CODE\\\' value=\\\'01\\\'> <br><select name=\\\'rating\\\'>\n<option value=\\\'5\\\' selected>5</option>\n<option value=\\\'4\\\'>4</option>\n<option value=\\\'3\\\'>3</option>\n<option value=\\\'2\\\'>2</option>\n<option value=\\\'1\\\'>1</option>\n</select>\n<input type=\\\'submit\\\' value=\\\'Rate!\\\'></form>','<center><b>%mtlname% Webring</b><br>\n
[ <a href=\\\'%url%?act=ring&id=%id%&op=back\\\'>Back</a> ] \n[ <a href=\\\'%url%?act=ring&id=%id%&op=backcat\\\'>Back (In this cat)</a> ] [ <a href=\\\'%url%?act=ring&id=%id%&op=random\\\'>Random Click</a> ] [ <a href=\\\'%url%?act=ring&id=%id%&op=nextcat\\\'>Next (In this cat)</a> ] [ <a href=\\\'%url%?act=ring&id=%id%&op=next\\\'>Next</a> ]</center>','1','1','','N;','N;','1','1200','1043152860','1','1200','1043152800','0','60','1041058560','0','60','1041058560','0','43200','1041688920','0','17280','1041688920','0','2592000','1066350420','0','648000','1070262000','1','3600','3,1,hour','60,1,hour','2,1,day','1,1,months','3,1,hour','60,1,hour','5,1,day','4,1,months')")
