Facebook  Twitter 

SMFHacks.com

+-

SMFHacks.com

+- User Information

Welcome, Guest.
Please login or register.
 
 
 
Forgot your password?

+- Forum Stats

Members
Total Members: 4255
Latest: andreios
New This Month: 3
New This Week: 1
New Today: 0
Stats
Total Posts: 43260
Total Topics: 7518
Most Online Today: 297
Most Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Members: 1
Guests: 245
Total: 246

Author Topic: Group by "Additional Categories"  (Read 3862 times)

0 Members and 1 Guest are viewing this topic.

Offline Senkusha

  • Member
  • *
  • Posts: 13
    • View Profile
    • Ayeka's Bliss: Anime Galaxy Network
Group by "Additional Categories"
« on: May 01, 2009, 09:43:23 am »
Hi, I needs some help with the product query.  Here's what I want to do:

If you've been to my store, you'll know that I've grouped each product in it's own category (named by the anime series title), and then I've added the additional category for the type of product it is.  So for example, what I'd llike is a break down like this (If I click on Ah My Goddess, I'll get)

Ah My Goddess
  DVD's:
{some products}

  Manga:
{some products}

  Books:
{some products}

  Accessories:
{some products}

However, if I click on DVD's I want the listing to be broken down by Primary Category (like the following)

DVD's
  Ah My Goddess
{some products}

  Azumanga Daioh
{some products}

  Happy Lesson
{some products}
...

I thought just by adding a GROUP BY was sufficient enough, but, it's not.  Do you have any suggestions for me?

Thanks!
--Senkusha
Visit my anime writing community

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 16436
    • View Profile
Re: Group by "Additional Categories"
« Reply #1 on: May 02, 2009, 09:30:37 pm »
What do you have so far for the query?
Get your Forum Ranked! at https://www.forumrankings.net - find out how your forum compares with others!

Like What I do? Support me at https://www.patreon.com/vbgamer45/

 

Related Topics

  Subject / Started by Replies Last post
1 Replies
4415 Views
Last post May 21, 2007, 06:37:59 pm
by SMFHacks
1 Replies
8882 Views
Last post September 28, 2007, 11:46:07 am
by smalldonkey
2 Replies
8183 Views
Last post November 06, 2007, 08:55:18 pm
by dry3210
11 Replies
14993 Views
Last post October 21, 2008, 07:43:10 pm
by Matt5L
2 Replies
5670 Views
Last post February 17, 2009, 10:36:44 am
by Nomi

+- Recent Topics

No thumbnails on new uploads by Tonyvic
Today at 06:26:18 am

Display the Contact Page for guests by SMFHacks
March 27, 2024, 10:55:43 am

is it possible to add support for odysee.com by fvlog19
March 21, 2024, 08:47:51 am

Request for admin notification by davejo
March 10, 2024, 01:31:59 am

I need help with torrent upload by Ineedsmfhelp
March 09, 2024, 10:01:13 pm

an idea for new mod (( content type with different display )) by SMFHacks
February 27, 2024, 01:36:27 pm

[Mod] RSS Feed Poster by SMFHacks
February 27, 2024, 11:57:18 am

find duplicate pictures by fvlog19
February 14, 2024, 02:22:40 pm

Error uploading video. by SMFHacks
February 08, 2024, 02:04:16 pm

Gallery icon as last added image by fvlog19
February 01, 2024, 01:04:56 pm

Powered by EzPortal