Re: [SOLVED] PHP form doesn’t save PHP – error #1064??

[nchipping]

Here’s a little more information that might help:

Just for reference, I finally put this in the PHPMyadmin MySQL query thing, and it gave me the following:

Code:

Error

SQL query:

UPDATE `content` SET `url` = ‘http://www.productionbook.com/home’,
`php` = ‘{startp} $hotdog = ‘chicken ‘; echo $hotdog; {/endp}’,
`meta` = ‘ ‘,
`page_title` = ‘home’,
`title` = ‘Home’,
`style` = ‘ ‘,
`script` = ‘ ‘,
`content` = ‘

Under construction This site is currently under construction. Please check back later.

‘,
`content_type_id` = ‘1’,
`analytics` = ‘ ‘,
`active` = ‘1’ WHERE `id` = ‘1’ LIMIT 1

MySQL said: Documentation
#1064 – 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 ‘chicken’; echo $hotdog; {/endp}’, `meta` = ‘ ‘, `page_title` = ‘home’, `title` =’ at line 1

When, what I put in (just for testing) –

Code:

UPDATE `content` SET `url` = ‘http://www.productionbook.com/home’, `php` = ‘{startp} $hotdog = ‘chicken’; echo $hotdog; {/endp}’, `meta` = ‘ ‘, `page_title` = ‘home’, `title` = ‘Home’, `style` = ‘ ‘, `script` = ‘ ‘, `content` = ‘
Under construction

This site is currently under construction. Please check back later.
‘, `content_type_id` = ‘1’, `analytics` = ‘ ‘, `active` = ‘1’ WHERE `id` = ‘1’ LIMIT 1

I had to put in the {startp} and {/endp} (made up tags) in order for it to try to save at all – if I use regular PHP tags it won’t even post it. Any ideas?