Re: [nyphp-talk] Using Pagination

2007-08-23 Thread drydell
actually, the most effective technique is very simple... all you need is a query, the page number you want and the number of items on a page.First execute your query but don't fetch the resuts. Keep in mind is that executing a query takes a fraction of the time & resources it takes to fetch the

Re: [nyphp-talk] Using Pagination

2007-08-23 Thread Gary Mort
PaulCheung wrote: I am really sorry to have to ask your help once again, but no matter how hard I try I can't seem to understand how pagination works I created a MySQL database called "test_db" and then set up the demo table "products". the products.php is just a dummy. nate.php is the codin

Re: [nyphp-talk] Using Pagination

2007-08-23 Thread Michael Southwell
At 01:36 PM 8/22/2007, you wrote: I am really sorry to have to ask your help once again, but no matter how hard I try I can't seem to understand how pagination works Paul, here is how I would approach your problem (if I have understood it correctly. I'm sure the experts on the list will be ab

[nyphp-talk] Using Pagination

2007-08-22 Thread PaulCheung
I am really sorry to have to ask your help once again, but no matter how hard I try I can't seem to understand how pagination works I created a MySQL database called "test_db" and then set up the demo table "products". the products.php is just a dummy. nate.php is the coding. I am trying to pa