Re: Re: [PHP-DB] php-mysql insert via web form problem

Hello, Thanks for your reply. I am not putting the \ slashes in the query, I think php is. However, I am not sure how to remove them from the query that is being sent to mysql. regards ~:P On Fri, 22 Feb 2002 09:58:27 +0200, Marius Ursache <marius.ursache@tm.cit.alcatel.fr> wrote: >i think the query you are sending to mysql should be : >insert into pages (page) values ('index') >(without \) > >pdsec@hushmail.com a écrit : > >> Hi, >> I am trying to write a web based form that I can put arbitrary sql >> statements into and run them against my mysql db. the form is written using >> php btw. >> >> For read operations this seems to work fine, i.e. select, describe, show >> etc. However, when I try to do an insert to a table I get an sql syntax >> error and I really can't see the problem. >> >> I am writting the query in a html textarea called query and then using >> this like so: >> $result=mysql_query($query,$link); >> >> I get this error in my browser when I run this: >> >> results of query: insert into pages (page) values (\'index\') >> Error:You have an error in your SQL syntax near '\'index\')' at line 1 >> >> And the query that produced this error is: >> insert into pages (page) values ('index') >> >> I've verified that this statement works using the commandline mysql >> interface. >> >> As the web server and db I'm trying to get this to work on are remote I'm >> not certain of the versions. I've tried using the insert into table_name set >> column_name=value form in case it was an older version of mysql , but this >> produces much the same error. >> >> Any suggestion greatly appreciated. >> >> ~:P >> >> Hush provide the worlds most secure, easy to use online applications - which solution is >> right for you? >> HushMail Secure Email http://www.hushmail.com/ >> HushDrive Secure Online Storage >> http://www.hushmail.com/hushdrive/ >> Hush Business - security for your Business >> http://www.hush.com/ >> Hush Enterprise - Secure Solutions for your Enterprise >> http://www.hush.com/ >> >> -- >> PHP Database Mailing List (http://www.php.net/) >> To unsubscribe, visit: http://www.php.net/unsub.php > >-- > Marius Ursache (3563 || 3494) > > \|/ ____ \|/ > "@'/ ,. \`@" > /_| \__/ |_\ > \__U_/ > > > Hush provide the worlds most secure, easy to use online applications - which solution is right for you? HushMail Secure Email http://www.hushmail.com/ HushDrive Secure Online Storage http://www.hushmail.com/hushdrive/ Hush Business - security for your Business http://www.hush.com/ Hush Enterprise - Secure Solutions for your Enterprise http://www.hush.com/