year_______month_______book name
--------------------------------------------------------
2002_________3_________book1 book2 book3
2002_________6_________book4 book5
2002_________8_________book6 book7 book8
Instead of displaying everything like this:
year_______month_______book name
--------------------------------------------------------
2002_________3_________book1
2002_________3_________book2
2002_________3_________book3
2002_________6_________book4
2002_________6_________book5
2002_________8_________book6
2002_________8_________book7
2002_________8_________book8
the existing code is:
Code: Select all
$query_rslist = "SELECT ID, year, month, book_name
FROM tbbook ORDER BY year ASC month ASC";
$query_limit_rslist = sprintf("%s LIMIT %d, %d", $query_rslist, $startRow_rslist, $maxRows_rslist);