Re: dynamic two column table
| From: | Mark Rees | Date: | Mon, 01 Aug 2005 12:18:50 +0000 |
| Subject: | Re: dynamic two column table | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-219741@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.
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