Re: Array Push and Keys

Correct on the brackets - but not on the results still working... The code I had in the email was just a sample - here is the real code... $res=mysql_query("select distinct dealercode from transactions order by dealercode",$intranet); $transactions=Array(); while($row=mysql_fetch_array($res)) { $amt=mysql_query("select sum(amount) as total from transactions where date between '2003-04-01' and '2003-06-31' and dealercode='$row[dealercode]'",$intranet); $afftotal=mysql_fetch_array($amt); array_push($transactions,$row[dealercode]=>Array("onlineu",$afftotal[total]) ); $amt=mysql_query("select usercountry,sum(amount) as total from orders_placed where date between '2003-04-01' and '2003-06-31' and dealercode='$row[dealercode]' and sent='y' group by usercountry",$intranet); while($cdtotal=mysql_fetch_array($amt)) { array_push($transactions[$row[dealercode]],$cdtotal[usercountry]=>$cdtotal[t otal]); } } And as for your offline suggestion of putting it into one query - I did try that first of course, but due to the large amount of data, and the shoddy nature of the database design (inherited not built) the query times out. This atleast returns within 1 min with the data when I can retrieve it :) Ideally the database would have one table with all the transaction information in it, and when I redesign it will, but in the meantime I am stuck with this... On 8/28/03 9:09 PM, "David Otton" <phpmail@jawbone.freeserve.co.uk> wrote: > On Thu, 28 Aug 2003 18:14:39 -0400, you wrote: > >> While($row=mysql_fetch_array($res) { > >> That *should* create the array above, but as I mentioned array_push does not >> seem to be taking the keys.... I just get a Parse error message for the >> line. (the first array_push) > > Ahem. Count the brackets? :) > > (On a style point, your code would be easier to read for bugs like this if > you added some whitespace.) -- Cheers Mike Morton **************************************************** * * Tel: 905-465-1263 * Email: mike@webtraxx.com * **************************************************** "Indeed, it would not be an exaggeration to describe the history of the computer industry for the past decade as a massive effort to keep up with Apple." - Byte Magazine Given infinite time, 100 monkeys could type out the complete works of Shakespeare. Win 98 source code? Eight monkeys, five minutes. -- NullGrey