I am allowing our members to upload pictures and they can choose which category the pictures go under, the first category "public" is made for them.
When I sql the DB I call it like this: select picture_names<,more fields> from <table> where member_id=<x> order by category.
which i display something like this:
__________________________________
| pic-here | <some text here> | category here|
| pic-here | <some text here> | category here|
---------------------------------------------
how can i display it like this:
__________________________________
category here |
---------------------------------------------
| pic-here | <some text here> |
| pic-here | <some text here> |
__________________________________
category here |
---------------------------------------------
| pic-here | <some text here> |
| pic-here | <some text here> |
---------------------------------------------
I thought of just getting the categories into an array and then sqling on each category but if there are 30 user defined categories that would mean 30 queries.... Another more complicated way would be to get all the records and sort them into arrays via categories and child arrays...I just feel this is too complicated for the above job.
Keep your query like it is... and do something like this:
$current_category = "";
while ( $row = db_get_object_function($db_result) ) {
if ($current_category != $row->category) {
print("$row->category header goes here");
$current_category = $row->category;
}
print("pic-here stuff goes here");
}