[Resolved] array/mysql question

KashKurcura

Hello:

My question is, how can I build an array like this;

$data=array(
"12-23-03" => 98,
"12-24-03" => 56,
"12-25-03" => 46,
"12-26-03" => 24,
"12-27-03" => 13,
"12-28-03" => 87,
"12-29-03" => 75
);

from a mysql query like this;

$sql = "Select Date, SUM(Amount) AS Totals FROM Sales GROUP BY Date";

Hope someone can help me.

scoppc

you need to use a WHILE loop, for sure...
in each iteration, assign the array:

while ($row=fetch($query)){
    $data[$row['date']]=$row['totals'];
}

KashKurcura

thanks for the reply but that output gives me something like this

[2002-12-07] => 1983.00
[2002-12-09] => 810.00
[2002-12-10] => 1078.00

but what I need is

"2002-12-07" => 1983.00,
"2002-12-09" => 810.00,
"2002-12-10" => 1078.00

any idea?

yahelb

  

while ($row=fetch($query)){ 
    $data["\"$row['date']\""]="$row['totals'],"; 
}

is that what you mean ?

KashKurcura

yahelb:

That kinda works but is there not way to make it so there are no braces?

["2002-07-12"] => 190.00,

needs to be

"2002-07-12" => 190.00,

tekky

nooo there isnt....

arrays are always indexed with []'s.....

if you want the out put of your script like that... then do something like this after your array is assigned

while(list($key, $val) = each($array))
{
     echo '"' . $key . '" => ' . $val . '<br>';
}

yahelb

i've lost you.

its already without braches ([]) isnt it ?

tekky

in after thought....

if you take the array you got from the $row['date'] method... and did print_r($array); you would get that output...

KashKurcura

thanks for all your replys. I have a script that uses the following arrary;

$data=array(
"12-23-03" => 98,
"12-24-03" => 56,
"12-25-03" => 46,
"12-26-03" => 24,
"12-27-03" => 13,
"12-28-03" => 87,
"12-29-03" => 75
);

but i would like to create that array from a mysql query but i cant figure that out using this query...

$sql = "Select Date, SUM(Amount) AS Totals FROM Sales GROUP BY Date";

tekky

Originally posted by KashKurcura
thanks for all your replys. I have a script that uses the following arrary;

$data=array(
"12-23-03" => 98,
"12-24-03" => 56,
"12-25-03" => 46,
"12-26-03" => 24,
"12-27-03" => 13,
"12-28-03" => 87,
"12-29-03" => 75
);

but i would like to create that array from a mysql query but i cant figure that out using this query...

$sql = "Select Date, SUM(Amount) AS Totals FROM Sales GROUP BY Date";

$sql = "Select Date, SUM(Amount) AS Totals FROM Sales GROUP BY Date";
$result = mysql_query($sql);
while($row=mysql_fetch_array($result))
{
     $data[$row['Date']] = $row['Totals'];
}
print_r($data);

KashKurcura

ok, that would produce an array like this, but when I run it in my program I get a parse error, expecting `')''

$Data = Array
(
[2003-10-09] => 655.00,
[2003-10-08] => 490.00,
[2003-10-07] => 225.00,
[2003-10-06] => 525.00,
[2003-10-05] => 500.00,
[2003-10-04] => 375.00,
[2003-10-03] => 565.00,
[2003-10-02] => 670.00,
[2003-10-01] => 250.00,
[2003-09-30] => 230.00,
);

but if I replace the [] with " " it works just fine

$Data = Array
(
"2003-10-09" => 655.00,
"2003-10-08" => 490.00,
"2003-10-07" => 225.00,
"2003-10-06" => 525.00,
"2003-10-05" => 500.00,
"2003-10-04" => 375.00,
"2003-10-03" => 565.00,
"2003-10-02" => 670.00,
"2003-10-01" => 250.00,
"2003-09-30" => 230.00,
);

any idea why? thanks for your help!

tekky

because print_r displays the ARRAY setup NOT The KEYS... you need to read www.php.net help files on ARRAYS.... Ill try and explain more after soccer practice..

tekky

^{^{^{^{^{^{^{^{^{^{^^^^^^^^}}}}}}}}}} this is wrong..... you will get an error as you've already seen..... to define an array you MUST have a comma dlimited list of VALUES (for numerically indexed arrays ie $var[1] = 'foo'😉 OR a comma delimited list of "quoted key names" => value (for KEYED arrays, ie $var['thiskey'] = 'thisvalue'😉

now....
print_r() will show you the ARRAY() function stored in that variable.... so you will see

$myarray = array(
'keyname' => value1,
'keyname2' => value2,
);

however, to ACCESS the data in this array you MUST use []'s

echo $myarray['keyname']; //outputs value1
echo $myarray['keyname2']; //outputs value2

now do you understand arrays a bit more?

you ARE getting the array you want... you just arent understanding how to access the data there....

but if I replace the [] with " " it works just fine

any idea why? thanks for your help! [/B][/QUOTE]