Print Page - newsletters SQL Syntax error

Title: newsletters SQL Syntax error
Post by: muslimways on February 17, 2006, 05:24:52 AM

Quote from: Database Error
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 '@yahoo.com', '[email protected]', '[email protected]', 'gestion2006dz@ya' at line 3
File: /home/.amethyst/muslimways/muslimways.com/forum/Sources/ManageNews.php
Line: 466

I get that error everytime I try to email, same line aswel, what could be wrong? please help

Title: Re: newsletters SQL Syntax error
Post by: Compuart on February 17, 2006, 11:38:32 AM

Try replacing:

Code (ManageNews.php) Select

WHERE emailAddress IN ('" . implode("', '", $send_list) . "')", __FILE__, __LINE__);

by:

Code (ManageNews.php) Select

WHERE emailAddress IN ('" . addslashes(implode("', '", $send_list)) . "')", __FILE__, __LINE__);

Title: Re: newsletters SQL Syntax error
Post by: muslimways on April 24, 2006, 05:19:38 AM

Thank you! ;)

Simple Machines Community Forum

Customizing SMF => SMF Coding Discussion => Topic started by: muslimways on February 17, 2006, 05:24:52 AM