php mysql associative array for graph report

Question

i need the output like below.i want to generate a graph for my report so i need the result in mysql_fetch_assoc. i am new to this concept. basically am doing mysql_fetch_array thats all but now i need the associative array function.

$date = array("date" => reading);

$data = array("28-Sep-2012" => .0032, "27-Sep-2012" => .0028, "29-Sep-2012" => .0021,
"24-Sep-2012" => .0033);

here below my query: $results = mysql_query("SELECT vaccum_value,date FROM vaccum_details where serial_number='10P1005'"); while($row = mysql_fetch_array($results)) { // i don't know what would be here? } — Sureshbalaji Gunasekaran
– Sureshbalaji Gunasekaran, Commented Oct 9, 2012 at 11:19

Prasath Albert · Accepted Answer · 2012-10-09 11:24:11Z

0

Try like this,

$results = mysql_query("SELECT vaccum_value,date FROM vaccum_details where serial_number='10P1005'");
$data=array();
while ($row = mysql_fetch_array($results))
{ 
    $data[$row['date']]=$row['vaccum_value'];
}

print_r($data);

answered Oct 9, 2012 at 11:24

Prasath Albert

1,45710 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Prasath Albert Over a year ago

@SureshbalajiGunasekaran: This is the simple PHP array functionality. create an array with date as key and vaccum_value as a array value.

Sureshbalaji Gunasekaran Over a year ago

but i need the output like this array("28-Sep-2012" => .0032, "27-Sep-2012" => .0028, "29-Sep-2012" => .0021, "24-Sep-2012" => .0033); instead of [] square bracket i need "" boss... after i run the script with ur code i got a output like this Array ( [28-Sep-2012] => 31.6 [04-Oct-2012] => 0.99 [03-Oct-2012] => -3 );

Prasath Albert Over a year ago

both are same.. the key of the array is string only.

Collectives™ on Stack Overflow

php mysql associative array for graph report

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related