Rasmus, solved this problem for me earlier today. Hope this helps
Rasmus,
Thank you very much. I ended up using the following statement, and it
works!!
> $results=mysql_query(stripslashes($sql_statement));
What I have now is a textarea box where I can input trial searches. This is
why I'm dealing with the whole sql statement. With time, I plan on passing
only the variables.
Thanks again.
Hugh
----- Original Message -----
From: Rasmus Lerdorf <[EMAIL PROTECTED]>
To: Hugh Danaher <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, July 18, 2001 1:49 AM
Subject: Re: [PHP] help on getting rid of \'
> > I am working with php and mysql and have the need to write a query like:
> >
> > $sql_statement=mysql_query(" select * from table where column='string'
");
> >
> > What comes out is:
> >
> > select * from table where column=\'string\'
>
> Only if you pass that variable through a GET/POST/COOKIE operation and you
> have magic_quotes_gpc enabled in your php.ini file. Either turn
> magic_quotes off or call stripslashes() on your string before passing it
> to MySQL.
>
> But, are you sure you want to be passing entire query strings between
> pages? Normally you would only pass the actual query arguments. In your
> case probably the 'string' part.
>
> -Rasmus
>
----- Original Message -----
From: hassan el forkani <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, August 07, 2001 7:32 AM
Subject: [PHP] mysql escape character \'
> greetings;
>
> i'm not sure if this is a mysql or php issue so i'm posting to both lists,
>
> i'm developping a community web site with news, forums......;
> while working on the admin section i noticed this behaviour:
>
> on my hosting platform (linux)
> i need to replace single quotes by \' to properly insert the data into the
> database and avoid errors
> on my dev machine (win98) there is no need to do so as single quotes are
> properly inserted and attempting to escape them actually inserts \'
instead
> of ';
>
> so the same code does not have the same output on windows and linux
>
> can someone explain??
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
