Manage mysql fetch array

Question

I have a mysql table that has data in it that I need to use in a more basic format.

There is ID number, Date, oil, gas and electric values.

I can do a mysql_fetch_array which brings back all the values I need but I need to view them in a format for use with a javascript chart. They need to be in the format:

$data = array(array("6/22/2009",425.32),array("6/8/2009",424.84),array("5/26/2009",417.23),array("5/11/2009",390));

As you can see I need the date and the oil values. Then I need to create another array with the date and electric values and finally the data and the gas values.

I'm not sure how to get the data from the mysql_fetch_array and add it to the array as shown above. Can anyone help?

can you post your code?

user1646111
– user1646111

2013-03-12 10:16:19 +00:00
Commented Mar 12, 2013 at 10:16 — user1646111
– user1646111, Commented Mar 12, 2013 at 10:16

Explosion Pills · Accepted Answer · 2013-03-12 10:16:11Z

2

You can just append it via the [] syntax:

$data = array('oil' => array(), 'gas' => array(), 'electric' => array());
while ($row = mysql_fetch_assoc($result)) {
    $data['oil'][$row['date']] = $row['oil'];
}

This assumes that the dates selected are unique as well.

By the way, you should avoid using mysql_* functions in new code.

answered Mar 12, 2013 at 10:16

Explosion Pills

192k56 gold badges341 silver badges417 bronze badges

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

Comments

om_deshpande · Accepted Answer · 2013-03-12 10:45:55Z

1

You need to use a 'numerical array':

    $result = mysql_query(" SELECT date, oil FROM energyprices");
    $i = 0;
    while($row = mysql_fetch_array($result, MYSQL_NUM))
    {
         $oil[$i] = array($row[0], $row[1]);
         $i++;
    }

Correct me if I haven't understood your question and I'll edit my answer accordingly.

answered Mar 12, 2013 at 10:45

om_deshpande

6651 gold badge5 silver badges17 bronze badges

Comments

Tapas Pal · Accepted Answer · 2013-03-12 10:21:55Z

0

Try this..

$finalArray=array();
while ($row = mysql_fetch_array($result)) 
{ 
    $data=array();
    $data[] = $row['date'];
    $data[] = $row['oil'];
    $finalArray[]=$data;
}
print_r($finalArray); //This will print your values in required fromat.

answered Mar 12, 2013 at 10:21

Tapas Pal

7,2578 gold badges45 silver badges90 bronze badges

Comments

Pete Naylor · Accepted Answer · 2013-03-12 10:36:23Z

0

Thanks for your help. I have amended my code to read this:

$oil = array('oil' => array());
$result=mysql_query(" SELECT * FROM energyprices");
while ($row = mysql_fetch_assoc($result)) {
$oil[$row['pDate']]['oil'] = $row['oil'];
}

When I print_r the data it looks like this:

Array ( [oil] => Array ( ) [2004-01-01] => Array ( [oil] => 29.73 ) [2004-01-02] => Array ( [oil] => 29.73 ));

The format I need it in is:

$oil = array(
array("6/22/2009",425.32),
array("6/8/2009",424.84),
array("5/26/2009",417.23));

Thank you!

answered Mar 12, 2013 at 10:36

Pete Naylor

7762 gold badges15 silver badges33 bronze badges

Collectives™ on Stack Overflow

Manage mysql fetch array

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related