retrieving data from db

[darrenclaveria]

pls help me. how can i retrieve data from my database and GROUP it by 5. like the one that attached. if its more than 5, an number below(page number) will appear and have a link to other group of data. hope you will understand and help me. thank you in advance

[freshnet]

You can't do this with the SQL, you'd need to return the result set and create a new page for every 5 rows. The best way to do that probably is to have a row counter variable that increments every time you output a result, and create a new page when that variable gets to 5, then reset the variable to 1.

[darrenclaveria]

i still dont know what approach gonna use

[TomCornar]

hi,you have to use pagination .check this link,

http://www.roseindia.net/sql/mysql-example/pagination.shtml

hope this helps.

Regards,
Tom Cornar
Trinay Technology Solutions
http://www.trinay.com

[BrianAlan]

a row counter variable that increments every time you output a result, and create a new page when that variable gets to 5, then reset the variable to 1.





-------------------------------
http://www.wholesaledvdsales.co.uk/