Justtechjobs.com Find a programming school near you






Online Campus Both


php-db | 2001051

RE: [PHP-DB] Url link From: Michael Rudel (mru <email protected>)
Date: 05/15/01

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:mru <email protected>
internet: http://www.suchtreffer.de
_______________________________________________________________

> -----Original Message-----
> From: Mark @ 10base-t.com [mailto:mark <email protected>]
> Sent: Monday, May 14, 2001 10:03 PM
> To: php-db <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: php-db-unsubscribe <email protected>
> For additional commands, e-mail: php-db-help <email protected>
> To contact the list administrators, e-mail:
> php-list-admin <email protected>
> 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>