Errore In Una Query

[luca__82]

nella query che scriverò di seguito c'è un errore, qualcuno sa dirmi dove ?

$query= " INSERT INTO maaking_options (`site_name`, `site_email`, `site_url`, `site_info`, `language`, `tmp_header`, `tmp_footer`, `validate`) VALUES
('maaking Login System', 'm@maaking.com', 'http://www.maaking.com/', 'login script, login, php, maaking,,,,,', 'english', '<div align="center">\r\n <table border="1" width="750" id="table1" cellpadding="2" bordercolor="#C0C0C0" height="74">\r\n <tr>\r\n <td bgcolor="#F2FAFF">go to setup and put all your \r\n stuff header here.</td>\r\n </tr>\r\n </table>\r\n</div>\r\n\r\n\r\n\r\n <div align="center">\r\n <table border="0" width="750" id="table2" cellspacing="4" cellpadding="4">\r\n <tr>\r\n <td>', '</td>\r\n </tr>\r\n </table>\r\n</div>\r\n\r\n\r\n\r\n<div align="center">\r\n <table border="1" width="750" id="table1" cellpadding="2" bordercolor="#C0C0C0" height="50">\r\n <tr>\r\n <td bgcolor="#F2FAFF">go to setup and put all your \r\n stuff footer here.</td>\r\n </tr>\r\n </table>\r\n</div>', 0) " ;

[Sky]

Ogni doppio apice presente nella query deve essere preceduto da un carattere di escape (il backslash: \ ) perché essa è racchiusa a sua volta dai doppi paici. Il parser quindi à errore.

Ecco la query corretta:

$query= " INSERT INTO maaking_options (`site_name`, `site_email`, `site_url`, `site_info`, `language`, `tmp_header`, `tmp_footer`, `validate`) VALUES
('maaking Login System', 'm@maaking.com', 'http://www.maaking.com/', 'login script, login, php, maaking,,,,,', 'english', '<div align=\"center\">\r\n <table border=\"1\" width=\"750\" id=\"table1\" cellpadding=\"2\" bordercolor=\"#C0C0C0\" height=\"74\">\r\n <tr>\r\n <td bgcolor=\"#F2FAFF\">go to setup and put all your \r\n stuff header here.</td>\r\n </tr>\r\n </table>\r\n</div>\r\n\r\n\r\n\r\n <div align=\"center\">\r\n <table border=\"0\" width=\"750\" id=\"table2\" cellspacing=\"4\" cellpadding=\"4\">\r\n <tr>\r\n <td>', '</td>\r\n </tr>\r\n </table>\r\n</div>\r\n\r\n\r\n\r\n<div align=\"center\">\r\n <table border=\"1\" width=\"750\" id=\"table1\" cellpadding=\"2\" bordercolor=\"#C0C0C0\" height=\"50\">\r\n <tr>\r\n <td bgcolor=\"#F2FAFF\">go to setup and put all your \r\n stuff footer here.</td>\r\n </tr>\r\n </table>\r\n</div>', 0) " ; 

Ciao

Daniele

[luca__82]

grazie daniè.....