Hi everyone,

I'm a dbase rookie and I've ran into a small problem.

I created a basic faq table and all is fine regarding displaying & searching the Q & A's on a web page.

Up until now, I;ve entered all Q & A's from phpMyAdmin.

I'm trying to create an admin page to enter the Q & A's and for the most part, it's working.

However, 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

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to