I hope everyone is doing well today. I have a question that may or may not be fairly easy to answer. I am building a search for a site that uses php/mysql to search a database of students and return the results.
The results are organized by academic quarter and then by last name within the quarter.
Here is the code:
Code: Select all
$result = mysql_query( "SELECT * FROM mentee WHERE published = 'yes' ORDER BY quarter DESC, trim(lastName)" )
or die("SELECT Error: ".mysql_error());All of the results are showing up fine, however, there is no real way to differentiate when the first quarter ends, and the second quarter begins (besides when the Last name letters start over at 'A' again).
Is there a way to insert say, a line break, in between the first, second, third, and so on quarters?
Any help would be greatly appreciated. Thank you all so much for your time and assistance, I know it is valuable.
-chazlink