Need to substitute #where# with $where

[comp.lang.php]

if ($willLimitByDB) $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

[noone]

comp.lang.php wrote:

if ($willLimitByDB) $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

given: $sql="select * from table";
and $where="where a = 'a'";

$sql .= $where;
//concatenate it before you edit it...
if ($willLimitByDB) $sql = preg_replace('/#([^#]+)#/i', '$$1', $sql);

[comp.lang.php]

noone wrote:

comp.lang.php wrote:

if ($willLimitByDB) $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

given: $sql="select * from table";
and $where="where a = 'a'";

$sql .= $where;
//concatenate it before you edit it...
if ($willLimitByDB) $sql = preg_replace('/#([^#]+)#/i', '$$1', $sql);

Thanx but you were looking at the wrong "WHERE.."

the query is this

"SELECT id, first_name, last_name, (SELECT count(id) #where#) as
paginate_total, email, address, city, state, zip, phone FROM person
$where "

You want "#where#" inside the subselect substituted with $where

I got it though thanx to someone that knows RegExp modifiers

$sql = preg_replace('/#([^#]+)#/ie', '$$1', $sql);

Phil

[Marcin Dobrucki]

comp.lang.php wrote:

"SELECT id, first_name, last_name, (SELECT count(id) #where#) as
paginate_total, email, address, city, state, zip, phone FROM person
$where "

You want "#where#" inside the subselect substituted with $where

So basically you are selecting "id, first_name, last_name ..." and
count of the returned results? Why not just ask the DB how many rows it
returned?

/marcin

[comp.lang.php]

Marcin Dobrucki wrote:

comp.lang.php wrote:

"SELECT id, first_name, last_name, (SELECT count(id) #where#) as
paginate_total, email, address, city, state, zip, phone FROM person
$where "

You want "#where#" inside the subselect substituted with $where

So basically you are selecting "id, first_name, last_name ..." and
count of the returned results? Why not just ask the DB how many rows it
returned?

/marcin

Because the resultset will have, for example, only 20 rows while the
entire table might have 20,000 rows. I must show how many total
records exist, all the while, only display a unit of 20.

Phil

[Marcin Dobrucki]

comp.lang.php wrote:

"SELECT id, first_name, last_name, (SELECT count(id) #where#) as
paginate_total, email, address, city, state, zip, phone FROM person
$where "

You want "#where#" inside the subselect substituted with $where
So basically you are selecting "id, first_name, last_name ..." and
count of the returned results? Why not just ask the DB how many rows it
returned?

Because the resultset will have, for example, only 20 rows while the
entire table might have 20,000 rows. I must show how many total
records exist, all the while, only display a unit of 20.

But your original post said:
"How do I substitute #where# with $where?"

So if your count-select is also governed by the same "where"
statement, then your count will be that of the selected set.

There are also simpler ways (IMHO) to get the total, eg, just run a
second separate select query with only count(id).

/m