I have 10 MySQL databases that feature the same table structures/names in each.
The table I am partically interested in is the Users
I need a way to display/paginate the results from each of the Users tables, and sort the data by category_colour
The table fields are:
id: INT(11)
name: varchar(255) - e.g. Dave, Lisa, Steve
category_colour: char(1) - Can be G = Green, O = Orange, B = Blue, O = Orange.
If I was to do this without paginate, there would be too many results, and the server would take an age to display them all.
I need the results to be categorized and in order of category_colour (1st: Red, 2nd: Green, 3rd: Blue, 4th: Orange) - Displaying the users database id
OUTPUT EXAMPLE:
Category Colour: Red
Dave - 1
Steve - 5
Fred - 4
etc
Category Colour: Green
Richard - 6
Kelly - 8
etc.
Category Colour: Blue
Emma - 3
Scott - 2
Louise - 7
etc.