Member Avatar for Taffd

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

  • 2 Contributors
  • 2 Replies
  • 66 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by Taffd

Recommended Answers

All 2 Replies

Member Avatar for phper

Do you have the column names?

Member Avatar for Taffd

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.