Displaying SQL results in a horizontal table

[james_sgp]

Help!!

I`m having difficulty working out how to display my query results in a horizontal table, similar to the one below:

My query is this:

SELECT MONTHNAME(dive_details_date), YEAR(dive_details_date), COUNT(*)
FROM jos_fabrik_formdata_9 WHERE dive_user = '${joomla_user_id}'
GROUP BY MONTHNAME(dive_details_date), YEAR(dive_details_date);

I would like to display lie this:

[dmacman1962]

What your looking for is called 'pagination' and one of THE best answers I have seen is here. This is by a person is named weedpacket, and is one of the best people who could ever help you and I have used this and it works every time.

Try it out, I think you will agree.

Regards,

Don