|
Posted by Dotan Cohen on 08/01/05 17:13
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
Navigation:
[Reply to this message]
|