This problem is probably related to my query, but I just can't figure out what I'm doing wrong.
This is the first time I have set up FCKeditor. I am editing several different fields, including one that uses FCKeditor.
This is the query I am attempting to make:
I get the 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 'WHERE page_content_id = '7')' at line 8
When I copy and paste the query directly into PHPMyAdmin, it works perfectly. So I am completely stumped. Apparently MySQL likes the query, but not the way I am trying to send it? I have tried to edit several different pages this way to no avail--I get the same error every time. I selected this particular page for the sample because it is has the shortest page text.
Any ideas/suggestions would be greatly appreciated!
Thanks,
--Eri
This is the first time I have set up FCKeditor. I am editing several different fields, including one that uses FCKeditor.
This is the query I am attempting to make:
UPDATE `page_content_t` SET title = 'View Shopping Cart - Store Name - Cambio Jeans, Joseph Ribkoff, Christopher Blue Jeans, A\'Nue Ligne', keywords = 'Store Name, cambio jeans, christopher blue jeans, joseph ribkoff dresses, a\'nue ligne, tolani collection', description = 'View Shopping Cart at Store Name.', header_image = 'view-cart.png', header_text = 'View Shopping Cart', page_content = '<p>When our online store is fully implemented you will be able to view the contents of your shopping cart here.</p>', WHERE page_content_id = '7'
I get the 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 'WHERE page_content_id = '7')' at line 8
When I copy and paste the query directly into PHPMyAdmin, it works perfectly. So I am completely stumped. Apparently MySQL likes the query, but not the way I am trying to send it? I have tried to edit several different pages this way to no avail--I get the same error every time. I selected this particular page for the sample because it is has the shortest page text.
Any ideas/suggestions would be greatly appreciated!
Thanks,
--Eri
Re: Getting Error Trying to Update MySQL Database
could you please post your complete PHP code here??