sciulli Posted April 19, 2006 Share Posted April 19, 2006 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_numbermens 1womens 2Table products--------------product_id product_desc product_cat34 long sleeve 135 short sleeve 2Table orders------------order_date order_id02-11-2005 302-10-2005 402-11-2005 5Table orders_products---------------------order_product_id order_id34 335 434 5Table orders_products_options------------------------------order_option_title order_product_value order_idsize large 3color blue 3size small 4color pink 4size medium 5color gray 5What I would like to do (if it's even possible) is:group each order by product_categoriesdisplay the category heading as underlinedif the order_option_title is "size" display the order_product_value in boldif the order_option_title is "color" display the order_product_value in italicsMens (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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.