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

Right then. Here's what I have done, and it works: ===Contents of query.txt======= <?php $fcontents = <<<QUERY select * FROM table where id='$value' order by name QUERY; ?> ===End Contents of query.txt=== Then: ===Contents of parse.php======= <?php include('query.txt'); preg_match_all("/^('\$(.*)')/si", $fcontents,$matches); print_r($matches) ?> ===End Contents of parse.php=== Now, whereas this works, I am still looking for a way to store and interpolate variables contained in "query.txt" without the kludge of having to embed the assignment of "$fcontents" inside the file as above :-( Have fun, Monu -----Original Message----- From: Hatem Ben [mailto:reflex_news@yahoo.fr] Sent: 12 June 2003 14:59 To: php-general@lists.php.net Subject: [PHP] Vars inside an sql query [Regular expression question] - Again 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