Hi Mark,

have a look @ http://www.php.net/manual/en/function.stripslashes.php

Greetinx,
  Mike

Michael Rudel
- Web-Development, Systemadministration -
_______________________________________________________________

Suchtreffer AG
Bleicherstraße 20
D-78467 Konstanz
Germany
fon: +49-(0)7531-89207-17
fax: +49-(0)7531-89207-13
e-mail: mailto:[EMAIL PROTECTED]
internet: http://www.suchtreffer.de
_______________________________________________________________



> -----Original Message-----
> From: Mark @ 10base-t.com [mailto:[EMAIL PROTECTED]]
> Sent: Monday, May 14, 2001 10:03 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] Url link
>
>
> Hey there,
> I'm trying to build NEXT/PREV buttons on my search page.
> The only way I know to do it so far is via an url.
>
> So the link I create is the following:
>
>
> http://monster/search1.php?offset=0&submit=submitted&where=his
> torical_yn%3D%
> 27N%27+and+fname+like+%27%25%25%27+and+lname+like+%27%25%25%27
> +and+dept+like
> +%27%2510%25%27+and+locid+like+%27%25%25%27+
>
> I'm passing the where= portion as a variable to my query string.
>
> $query = "select blah from employee where $where order by
> blah limit blah"
>
> But it makes the where section into this:
>
> select id, lname, fname, extension, locid, email from employee where
> historical_yn=\'N\' and fname like \'%%\' and lname like
> \'%%\' and dept
> like \'%10%\' and locid like \'%%\' order by lname limit 1,20
>
>
> The problem is it's putting \'s in the where variable and it
> makes the query
> fail.
>
> Does anyone know how best to get rid of the \'s or a better way to do
> next/prev buttons?
>
> Thanks!!!
>
> Mark
>
>
>
> --
> PHP Database 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 Database 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]

Reply via email to