[thelist] Re: thelist digest, Vol 1 #2753 - 32 msgs

[Richard Hall]

>
> doh! (slaps head). Ok, this is CLOSE to what I wanted. It prints the
> category out and then the item. I think I didn't state this right - I
> only want to print the category out ONCE - then print out the related
> items. I only want:
>
> Category:
>
> Item in cat
> item in cat
> item in cat
>
> Do I have to go back to the SQL for this or the PHP?
>
> Tom
>

/* Change the PHP. see psuedocode */

$Category = ''
CURSOR LOOP
    IF Fetched Category diffrerent from $Category THEN
        Display Fetched Category
        $Category = Fetched Category
    END IF
    Display Item
END LOOP

Rick