[PHP] Vars inside an sql query [Regular expression question]

[Hatem Ben]

Greetings all,

I got a headache doing this, i need to get vars inside an sql query. For example :

$query = "select * FROM `table` where id='$value' order by name";
preg_match_all("/^('\$(.*)')/si", $query,$matches);

any help plz ?

Thanks,
Hatem