CodingForums.com - View Single Post

Old Pedant · 11-26-2012, 10:05 PM

If you wanted to see something like this:

Code:

group        product     price    lowest price
television   lg            $388     $388
television   rca           $430     $388
television   sony          $478     $388
microwave    amana         $138     $138
microwave    panasonic     $158     $138
microwave    ge            $169     $138

that CAN AND SHOULD be all done in a SQL query.

And then your PHP code would just pull the data from the records and display it with no futher PHP processing.

If that's what you are after, provide some sample data to work with and I'll show you how.

11-26-2012, 10:05 PM	PM User \| #11
Old Pedant Supreme Master coder! Join Date: Feb 2009 Posts: 23,237 Thanks: 59 Thanked 3,998 Times in 3,967 Posts	If you wanted to see something like this: Code: group product price lowest price television lg $388 $388 television rca $430 $388 television sony $478 $388 microwave amana $138 $138 microwave panasonic $158 $138 microwave ge $169 $138 that CAN AND SHOULD be all done in a SQL query. And then your PHP code would just pull the data from the records and display it with no futher PHP processing. If that's what you are after, provide some sample data to work with and I'll show you how. __________________ An optimist sees the glass as half full. A pessimist sees the glass as half empty. A realist drinks it no matter how much there is.