WOrked like a charm thanks! I am still kinda news at doing anything beyond
the simple query.
WHen i look at what you did it makes total sense, just couldn't seem to get
the ole brain
to figure it out! :)
> Looks like what you need to do is :
>
> SELECT SI_Categories.SI_Category_ID, SI_Categor
Hi Kelly,
>
> So basically SI_Items has the category ID for each item to show what
> category it belongs to. All Good...
> I want the output however to look like so.
>
[snip]
> I seem to be having trouble. Obviously something has to loop and
> maybe even
> group (ooo a rhyme)
> because once I pul
why not just do a joined query?
SELECT
c.SI_Category_name,
i.si_item_name
FROM
SI_categories c,
si_items i
WHERE
c.category_id = i.category_id
ORDER BY
c.si_category_name, i.si_item_name
then, when you output, do a
#si_category_name#
...
C
3 matches
Mail list logo