Re: Creating single row for multiple items.

From: Date: Tue, 09 Sep 2008 23:31:23 +0000
Subject: Re: Creating single row for multiple items.
References: 1  Groups: php.general 
Request: Send a blank email to php-general+get-279758@lists.php.net to get a copy of this message
At 10:04 PM -0600 8/31/08, Tom Shaw wrote:
My array looks very similar to this. I need to create a single row for the items that have the same order number for CSV export. I'd prefer to do this PHP wise instead of SQL. But would appreciate any help I can get. $ar = array( array(
     "order_id" => "34",
     "order_number" => "35Y345Y356YU3",
     "order_name" => "Steinway Grand Piano #11",
     "order_ordered_size" => "Grand",
     "order_sales_price" => "78671.90",
     "order_shipping_price" => "7.85",
     "order_shipping_extra" => "0.06",
),
My first question is: $78 THOUSAND DOLLARS FOR A FRAKING PIANO ???!!!??? Now that I've composed myself. What's wrong with use MySQL and letting it do the hard stuff? After all, what you are attempting to do is what MySQL works best at -- namely pull all all the records that have the same order number. Why make it harder on yourself? Cheers, tedd -- ------- http://sperling.com http://ancientstones.com http://earthstones.com

« previous php.general (#279758) next »