Hi,
I have a table with 10,000 names.
I'd like to group them into groups of 3 and also display the remaining 1.
Can anybody help with a suitable query please.

Taffd

Do you have the column names?

Hi phper,
There is only one column - 'name'.

The table is called 'names'.

Research I've done suggests this cannot be done with sql and will need to be done with php - but I can't work out how to do that either.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.