Re: Whimper, help :)

Peter Houchin wrote: Mostly varchar(255) and a couple of text. (I may have one longtext). But should that make a difference? Like I said, I can run the same SQL in PHPMyAdmin (a MySQL interface) and I get the correct reponse. But pass it through PHP and kablooey. Won't work? John > what are the field types in the mysql DB? > > > -----Original Message----- > > From: John Taylor-Johnston [mailto:taylorjo@collegesherbrooke.qc.ca] > > Sent: Wednesday, 4 December 2002 4:13 PM > > To: php-general@lists.php.net > > Subject: Re: [PHP] Whimper, help :) > > > > > > Tom, > > Anyone, > > > > No I'm not looking for a ", I'm trying to pass double quotes into MySQL. > > Like I said, it works when debugging: > > > > > > http://ccl.flsh.usherb.ca/print/print.html?search=%26quot%3Bready+ > > maria%26quot%3B > > http://ccl.flsh.usherb.ca/print/display.test.inc.phps > > > > but fails when I try to pass my double quotes in: > > > > > > http://ccl.flsh.usherb.ca/print/index.html?search=%26quot%3Bready+ > > maria%26quot%3B > > http://ccl.flsh.usherb.ca/print/display.table.inc.phps > > > > $sql = "SELECT id,AU,ST,BT,AT FROM $table WHERE MATCH > > (TNum,YR,AU,ST,SD,BT,BC,AT,PL,PR,PG,LG,AUS,KW,GEO,AN,RB,CO) > > AGAINST ('".stripslashes($search)."' IN BOOLEAN MODE) ORDER BY id > > asc"; > > > > I already have the <input type=text name=search> $search > > > > I have tried many variations. > > > > > If you are looking for " in a string just quote it with ' > > > example > > > $like = '"ready maria"'; > > > $ sql = " SELECT .......... WHERE .... LIKE '$like'"; > > > no need to escape anything > > > > > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > -- John Taylor-Johnston ----------------------------------------------------------------------------- "If it's not open-source, it's Murphy's Law." ' ' ' Collège de Sherbrooke: ô¿ô http://www.collegesherbrooke.qc.ca/languesmodernes/ - Université de Sherbrooke: http://compcanlit.ca/ 819-569-2064