Re: Vars inside an sql query [Regular expression question] - Again

Well, it's finally working, but still very confusing ... thanks all <?php $fcontents = join('' , file('query.txt')); preg_match_all('/(\'\$(.*)\')/si', $fcontents,$matches); print_r($matches) ?> Regards, Hatem ----- Original Message ----- From: "Hatem Ben" <reflex_news@yahoo.fr> To: <php-general@lists.php.net> Cc: "Marek Kilimajer" <kilimajer@webglobe.sk> Sent: Thursday, June 12, 2003 4:35 PM Subject: Re: [PHP] Vars inside an sql query [Regular expression question] - Again > It's not working also > > ----- Original Message ----- > From: "Marek Kilimajer" <kilimajer@webglobe.sk> > To: "Hatem Ben" <reflex_news@yahoo.fr> > Cc: <php-general@lists.php.net> > Sent: Thursday, June 12, 2003 5:23 PM > Subject: Re: [PHP] Vars inside an sql query [Regular expression question] - > Again > > > > preg_match_all("/^('\$(.*)')/si", $fcontents,$matches); > > ^^ > > you don't allow any character between start of the string and single > quote. > > preg_match_all("/^.*('\$(.*)')/si", $fcontents,$matches); > > > > > > Hatem Ben wrote: > > > I'm asking again the same question, coz i guess my question wasn't > clear. > > > > > > i just need to retreive vars inside query.txt, my regular expression > seems to be correct for me, but i don't find why it doesn't wrk > > > > > > ------ Starting query.txt > > > select * FROM table where id='$value' order > > > by name > > > ------ Ending query.txt > > > > > > > > > ------ Starting parse.php > > > <?php > > > $fcontents = join('' , file('query.txt')); > > > preg_match_all("/^('\$(.*)')/si", $fcontents,$matches); > > > print_r($matches) > > > ?> > > > --------- Ending parse.php > > > > > > > > > rewriting query is another question, that i agree also. > > > > > > Thanks > > > Hatem > > > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php