March 26th, 2000, 05: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, 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).]
March 26th, 2000, 11: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, 02:19 PM
March 27th, 2000, 02:32 PM
Thanks it worked. Within a week my project will be done. Yieha! :-)