in your php.ini have something about magic_quotes. read the manual.
[EMAIL PROTECTED] a écrit :
> 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
><[EMAIL PROTECTED]> wrote:
> >i think the query you are sending to mysql should be :
> >insert into pages (page) values ('index')
> >(without \)
> >
> >[EMAIL PROTECTED] 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/
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
--
Marius Ursache (3563 || 3494)
\|/ ____ \|/
"@'/ ,. \`@"
/_| \__/ |_\
\__U_/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
