|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
March 26th, 2000, 05:41 AM
|
|||
|
|||
|
Hi there!
When I read from mysql database it shows all the records. How can i make them show by 5 each page? Thanx! -Jonathan
|
|
#2
March 26th, 2000, 05:53 AM
|
||||
|
||||
|
Use The "limit" for limited number of record display.
I am giving a small example here "select * from tablename order by fieldname ascending limit 5" [This message has been edited by Shiju Rajan (edited March 26, 2000).]
|
|
#3
March 26th, 2000, 11:26 AM
|
|||
|
|||
|
Hi,
I knew the syntax in mySQL how do I process it in php? You know, the page shows 5 records and it has a link to 'next page'... I think the summertime is bad for a mans brain:-/ -Jonathan
|
|
#4
March 26th, 2000, 02:19 PM
|
|||
|
|||
|
Check out the article:
http://www.phpbuilder.com/columns/rod20000221.php3 This isn't 'production code' but will give you the idea of how to do it for your application.
|
|
#5
March 27th, 2000, 02:32 PM
|
|||
|
|||
|
Hi,
Thanks it worked. Within a week my project will be done. Yieha! :-) -Jonathan
|
|
| Viewing: Dev Shed Forums > Programming Languages > PHP Development > Limited records showing |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
