March 26th, 2000, 04:41 AM
When I read from mysql database it shows all the records. How can i make them show by 5 each page?
March 26th, 2000, 04: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).]
March 26th, 2000, 10:26 AM
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:-/
March 26th, 2000, 01:19 PM
March 27th, 2000, 01:32 PM
Thanks it worked. Within a week my project will be done. Yieha! :-)