[EMAIL PROTECTED] wrote:
> I keep getting the following 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 's
> resources than dual monitor mode to generate the video output. Running
> in dual' at line 2
>
> when I try to add:
>
> Note : Single-monitor mode uses more of your computer's resources than
> dual monitor mode to generate the video output. Running in dual monitor
> mode is recommended because it is more efficient.
>
>
> My PHP code to add Q & A is:
>
> mysql_query("INSERT INTO faqs
> (Question, Answer, Category, Date) VALUES('$question', '$answer',
> '$category', CURDATE() ) ")
> or die(mysql_error());
>
> If I enter the above text directly intophpMyAdmin, all is fine.
>
> Any help is greatly appreciated.
>
> Thanks
>
> Haig
Haig,
$questionEscaped = mysql_real_escape_string($question);
mysql_query("INSERT INTO faqs
(Question, Answer, Category, Date) VALUES('*$questionEscaped*',
'$answer',
'$category', CURDATE() ) ")
or die(mysql_error());
You need to escape the single quote in your FAQ.
David
Thanks guys for all your input. Greatly appreciated!!
Escaping the single quotes did the trick.
Haig
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
