What i'm trying to do -

Have an online store that has product categories which are displayed using the 'group by' sql. that part simple.

What i want to do now is be able to show a picture next to the category name that relates to that category?

So a product picture from that category will be displayed next to the category name.

Any help would be appreciated.

Regards

Simon

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>...What i want to do now is be able to show a picture next to the category name that relates to that category?

So a product picture from that category will be displayed next to the category name.<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
At the minimum, add a column in the category table and have records point to what image is its' icon, and have it show if the field is not NULL or empty.

Otherwise, you can use another table that's icons, and categoryID's and do the same as above, but just in a seperate table.

Hope those help.

Excellent - It always helps to get an outside view - i'll give it a try.

Many thanks

regards

simon