Jump to content

sciulli

New Members
  • Posts

    1
  • Joined

  • Last visited

    Never

Posts posted by sciulli

  1. I've spent 6+ hours and have only managed to get errors, all results on one line, or all the results in the same format. I could post some of my sample code, but it's useless. If someone could point me in the right direction, or even provide a relevant tutorial link for this type of process it would be greatly appreciated.

    I am trying to query the database to list all orders while grouping them by category and displaying different rows in different formats. Here's a sample of my database:

    Table product_categories
    ------------------------
    product_cat_desc product_cat_number
    mens 1
    womens 2

    Table products
    --------------
    product_id product_desc product_cat
    34 long sleeve 1
    35 short sleeve 2

    Table orders
    ------------
    order_date order_id
    02-11-2005 3
    02-10-2005 4
    02-11-2005 5

    Table orders_products
    ---------------------
    order_product_id order_id
    34 3
    35 4
    34 5

    Table orders_products_options
    ------------------------------
    order_option_title order_product_value order_id
    size large 3
    color blue 3
    size small 4
    color pink 4
    size medium 5
    color gray 5

    What I would like to do (if it's even possible) is:
    group each order by product_categories
    display the category heading as underlined
    if the order_option_title is "size" display the order_product_value in bold
    if the order_option_title is "color" display the order_product_value in italics

    Mens (underlined)

    Large (in bold)
    blue (in italic)

    Medium (in bold)
    gray (in italics)

    Womens (underlined)

    Small (in bold)
    pink (in italics)

    Thanks in advance to anyone who can guide me.
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.