Re: [PHP] count() total records for pagination with limit

2009-04-14 Thread PJ
Chris wrote: > PJ wrote: >> I seem to recall that it is possible to count all instances of a query >> that is limited by $RecordsPerPage without repeating the same query. I >> believe that COUNT() had to called immediately after the SELECT word but >> I neglected to bookmark the source. Dummy! > >

Re: [PHP] count() total records for pagination with limit

2009-04-14 Thread Chris
PJ wrote: I seem to recall that it is possible to count all instances of a query that is limited by $RecordsPerPage without repeating the same query. I believe that COUNT() had to called immediately after the SELECT word but I neglected to bookmark the source. Dummy! You're probably thinking of

[PHP] count() total records for pagination with limit

2009-04-14 Thread PJ
I seem to recall that it is possible to count all instances of a query that is limited by $RecordsPerPage without repeating the same query. I believe that COUNT() had to called immediately after the SELECT word but I neglected to bookmark the source. Dummy! I don't like the idea of count(*) over co

RE: [PHP] Count total

2001-08-19 Thread Don Read
On 19-Aug-2001 Martin Kampherbeek wrote: > Hi, > > Who can help me with the following problem? > I have the tables score and totalscore. > > Score: > id > userid > name > score > > Totalscore: > userid > name > totalscore > > In the table score one user can have mutiple scores. But in totalsc

Re: [PHP] Count total

2001-08-19 Thread Rasmus Lerdorf
On Sun, 19 Aug 2001, Martin Kampherbeek wrote: > Hi, > > Who can help me with the following problem? > I have the tables score and totalscore. > > Score: > id > userid > name > score > > Totalscore: > userid > name > totalscore > > In the table score one user can have mutiple scores. But in total

Re: [PHP] Count total

2001-08-19 Thread Chris Lambert
2001 5:34 AM Subject: [PHP] Count total Hi, Who can help me with the following problem? I have the tables score and totalscore. Score: id userid name score Totalscore: userid name totalscore In the table score one user can have mutiple scores. But in totalscore the userid is unique. Now I want to c

[PHP] Count total

2001-08-19 Thread Martin Kampherbeek
Hi, Who can help me with the following problem? I have the tables score and totalscore. Score: id userid name score Totalscore: userid name totalscore In the table score one user can have mutiple scores. But in totalscore the userid is unique. Now I want to count all the score's of a user en