Posted by Marcin Dobrucki on 11/18/62 11:42

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

[Back to original message]