Lawrence D'Oliveiro wrote:
> Bryan Olson wrote:
>
>> Lawrence D'Oliveiro wrote:
>>> In Bryan Olson wrote:
>>>
coldpizza wrote:
> It turned out that the method above ('SELECT * FROM TABLE LIMIT L1,
> L2') works ok both with mysql and sqlite3, therefore I have decided to
> stick wit
In message <[EMAIL PROTECTED]>, Bryan Olson
wrote:
> Lawrence D'Oliveiro wrote:
>> In Bryan Olson wrote:
>>
>>> coldpizza wrote:
It turned out that the method above ('SELECT * FROM TABLE LIMIT L1,
L2') works ok both with mysql and sqlite3, therefore I have decided to
stick with it
Lawrence D'Oliveiro wrote:
> In Bryan Olson wrote:
>
>> coldpizza wrote:
>>> It turned out that the method above ('SELECT * FROM TABLE LIMIT L1,
>>> L2') works ok both with mysql and sqlite3, therefore I have decided to
>>> stick with it until I find something better. With Sqlite3 you are
>>> supp
In message <[EMAIL PROTECTED]>, Bryan Olson
wrote:
> coldpizza wrote:
>> It turned out that the method above ('SELECT * FROM TABLE LIMIT L1,
>> L2') works ok both with mysql and sqlite3, therefore I have decided to
>> stick with it until I find something better. With Sqlite3 you are
>> supposed to
coldpizza wrote:
> It turned out that the method above ('SELECT * FROM TABLE LIMIT L1,
> L2') works ok both with mysql and sqlite3, therefore I have decided to
> stick with it until I find something better. With Sqlite3 you are
> supposed to use LIMIT 10 OFFSET NN, but it also apparently supports
>
On 2007-09-23 01:11, coldpizza wrote:
> Hi,
>
> I want to run a database query and then display the first 10 records
> on a web page. Then I want to be able to click the 'Next' link on the
> page to show the next 10 records, and so on.
>
> My question is how to implement paging, i.e. the 'Next/Pr
On Sep 24, 7:23 am, Lawrence D'Oliveiro <[EMAIL PROTECTED]
central.gen.new_zealand> wrote:
> In message <[EMAIL PROTECTED]>, coldpizza
> wrote:
>
> > So far, with mysql I use 'SELECT * FROM TABLE LIMIT L1, L2' where L1
> > and L2 define the range for the 'Next' and 'Previous' commands. I
> > have
coldpizza wrote:
>Hi,
>
>I want to run a database query and then display the first 10 records
>on a web page. Then I want to be able to click the 'Next' link on the
>page to show the next 10 records, and so on.
>
>My question is how to implement paging, i.e. the 'Next/Prev' NN
>records without ree
In message <[EMAIL PROTECTED]>, coldpizza
wrote:
> So far, with mysql I use 'SELECT * FROM TABLE LIMIT L1, L2' where L1
> and L2 define the range for the 'Next' and 'Previous' commands. I
> have to run the query every time a click a 'Next/Prev' link. But I am
> not sure that this is the best and
coldpizza wrote:
> I want to run a database query and then display the first 10 records
> on a web page. Then I want to be able to click the 'Next' link on the
> page to show the next 10 records, and so on.
> My question is how to implement paging, i.e. the 'Next/Prev' NN
> records without reestab
Hi,
I want to run a database query and then display the first 10 records
on a web page. Then I want to be able to click the 'Next' link on the
page to show the next 10 records, and so on.
My question is how to implement paging, i.e. the 'Next/Prev' NN
records without reestablishing a database con
11 matches
Mail list logo
