> i know how to break up db results into two tables but im having a hard > problem with this: > > db structure > > --------------- > | id | cid | title > --------------- > | 1 | 2 | hardware > | 2 | 3 | software > | 3 | 3 | software > | 4 | 2 | hardware > > > how can i have hardware on column 1 and software on column 2 using 1 > query? i thought a simple if statement on cid might do it but regardless > it spreads the results on both columns.
Can you give an example of what you want the output to look like? > > thanx. > > > -- > No virus found in this outgoing message. > Checked by AVG Anti-Virus. > Version: 7.0.338 / Virus Database: 267.9.7/60 - Release Date: 7/28/2005 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
