Hi, anyone know how to automatically select every 4 values from a mysql database?
I will try to explain better. Let’s say I have a table with 20 rows. What i need to do is to show row 1,4,8,12,16 and 20 wih one query, than start again and show rows number 2,5,9,13,17 and than, 3,6,10,14,18 and than 4,7,11,15,19 and at last 5,12,16
Is this possible? How do i set the values of LIMIT?
Thanks a lot!