Substitute #where# with $where

[ppowell]

if ($willLimitByD😎 $sql = preg_replace('/#([^#]+)#/i', '$$1', $sql);

This does not give me the results I want, instead of the value of $where in $sql, I literally get '$where' instead.

How do I substitute #where# with $where?

Thanx
Phil

[laserlight]

$sql = preg_replace('/#([a-z_][a-z0-9_]*)#/ie', '$$1', $sql);

Notice the 'e' pattern modifier.

[ppowell]

Hmm.. that worked in that case but now I get inaccurate results in my field "pagination_total" which is fed according to that PHP line..

I'm confused as to why 'e' modifier works as well

Thanx
Phil