|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#3
July 19th, 2000, 01:28 AM
|
|||
|
|||
|
paging means displaying records in break system .like it is done when u search something like next page & page nos are shown
& i have an assignment that i have to do in Active server pages only so reply back if u know about it <BLOCKQUOTE><font size="1" face="Verdana,Arial,Helvetica">quote:</font><HR>Originally posted by SepodatiCreations: what do you mean by paging? why use asp? ---John Holmes...[/quote] ------------------ catch me at beedeep@rediffmail.com
|
|
#4
July 19th, 2000, 12:09 PM
|
|||
|
|||
|
To page using mySQL you have to use the LIMIT command like this
SELECT fields ... FROM table LIMIT $offset,$pgsize store the page number you are on in your html form as a hidden field or a cookie or whatever you're comfortable with so that you can pass it back to your ASP or CGI in order to figure out the next $offset (i.e. $offset = ($pg-1) * $pgsize) Hope this helps Dan
|
|
| Viewing: Dev Shed Forums > Databases > MySQL Help > Paging in mysql |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
