Result and Sort by Date

2. Combine the results of your 3 select in a single array, and sort this new array, maybe with usort, depending on the content: https://www.php.net/usort

I thought this might work too but it seems to me that the combined array has to sort by keys. A sort by value is - pardon the pun - of no value. (usort sorts on values)

If we use dates for the keys we are limited to one date in the array.

Maybe a UNION will work.

UPDATE

It seems a UNION will work. I used the query below in phpMyAdmin and got the desired results. The various "date" columns all use the "date" datatype.

Code:

SELECT DATE_FORMAT(`registerDate`, '%m-%d-%Y') AS 'Date',`registerStatus` AS 'Function',`registerUserName` AS 'Name' FROM `registerdata` WHERE `schoolID`=5
UNION
SELECT DATE_FORMAT(`SuspendDate`, '%m-%d-%Y'),`SuspendStatus` ,`SuspendUserName` FROM `SuspendedData` WHERE `schoolID`=5
UNION
SELECT DATE_FORMAT(`UpdateDate`, '%m-%d-%Y'),`UpdateStatus` ,`UpdateUserName` FROM `UserUpdateLog` WHERE `schoolID`=5
ORDER BY `Date` DESC

So that means only one query and resulting dataset, so the view only needs one foreach loop.