RE: [PHP-DB] Url link

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@suchtreffer.de internet: http://www.suchtreffer.de _______________________________________________________________ > -----Original Message----- > From: Mark @ 10base-t.com [mailto:mark@10base-t.com] > Sent: Monday, May 14, 2001 10:03 PM > To: php-db@lists.php.net > 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@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: > php-list-admin@lists.php.net >