formatting logic

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi,
Am having a bit of logic problem figuring this out....I just think the easy
solution would cost me in having too many
sql queries from my script so there has to be a easier way.


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|
| 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>                         |
| 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.

What am I missing?

Thanks,
Ryan



-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.10.1 - Release Date: 4/20/2005

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux