Re: Re: dynamic two column table

On 8/1/05, Mark Rees <mrees@itsagoodprice.com> wrote: > > 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. > > Use an array for each, and in each row of the table output another field of each array (with a while loop). I do that on http://lyricslist.com Dotan Cohen http://IE-only.com