[snip]
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());
[/snip]
You need to escape your $question and $answer variables, the
apostrophe's contained there are goofing you up.
http://www.php.net/mysqlrealescapestring
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
