Re: How can we split the record from db ?

If you use mysql, you can use such a query like this: "SELECT * FROM table LIMIT $start, $rownum" Where $start is where the slice starts, $rownum is the number of rows... Please ask further questions on our mailing lists. You can subscribe to one at http://www.php.net/support.php Goba [one webmaster@php.net] ----- Original Message ----- From: Mohamed Almojawer To: webmaster@php.net Sent: Friday, October 12, 2001 12:13 AM Subject: How can we split the record from db ? How can we split the result that comes from database such that just 10 record displayed in the page and the visitor can see more when click in Next page link. My friend told mw that I should use offset and limit function but I don't know how. Please show me how can I do that ? Thanks ------------------------------------------------------------------------------ Do You Yahoo!? Make a great connection at Yahoo! Personals.