Re: 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 > >