dynamic two column table
| From: | Sebastian | Date: | Sun, 31 Jul 2005 00:58:15 +0000 |
| Subject: | dynamic two column table | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-219702@lists.php.net to get a copy of this message | ||
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.
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