What I want to be able to do is select the results from the database and then display them in a table with four columns.. for example..

<table border>
<tr>
<td width="100">Result 1</td>
<td width="100">Result 2</td>
<td width="100">Result 3</td>
<td width="100">Result 4</td>
</tr>
</table>

But also only display 4 rows per page and then have links to go to the next and previous pages which will display another 16 results (4 rows x 4 columns)

So if anyone could point me towards a tutorial or provide the coding that would be great!

Thanks

Anyone?

If you need any more information just ask.

Thanks!

I assume you're using a scripting language like PHP or Perl to accomplish this?

When MySQL 4+, you can use "select sql_calc_found_rows, field1, field2..." where 'sql_calc_found_rows' lets you make another query ("select found_rows()") that returns the total number of rows.

So what you have to do is select the data you want, and then have a "limit" statement at the end of your query - for example, "limit $offset, 4". The $offset is by default set to 0. If you find out that the total # of rows that would have been returned (without the limit - you get this from the 'found_rows()' query) is greater than 4, then you need to print a "Next" link where you increment the $offset variable by 4. So, the first time the query is run, the limit statement will be "limit 0, 4" (select the first 4 rows). When someone clicks on 'next', it will be "limit 4, 4" (select rows 5-8).

For previous, just check of $offset is greater than 0. If it is, print a "Previous" link that sets $offset to $offset - 4;

Good luck!

Thanks, although I pretty much have the pagination sorted. All I really need to know is how to display the results in the four columns.. Although I've decided to do it a different way now but if anyone can help with putting the results into the columns that would hlp for the future.

Thanks!

This tutorial will get you sorted: LINK.