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

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
Assuming MySQL... /* Chris Lambert, CTO - [EMAIL PROTECTED] WhiteCrown Networks - More Than White Hats Web Application Security - www.whitecrown.net */ - Original Message - From: Martin Kampherbeek <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, August 19, 2001 5:34 AM Subject