Create array from query

[localhost]

Hello
Im trying to generate an array from ths query:

while ($query=mysql_fetch_array(mysql_query("SELECT time,score  FROM statistics 
")))
{
//generate array...how???
}

the array should look like this

$data = array(
    array(  "", 2000,     750),
    array(  "", 2010,    1700),
    array(  "", 2015,    2000),
    array(  "", 2020,    1800),
    array(  "", 2025,    1300),
    array(  "", 2030,     400)
);

the values 2000,2010 etc correspond to field [ time]
the values 750,170etc correspond to field [ score]

how do i create this array??

Thanks!

[website]

I would defenatnly not do it this way. Rather I would do it like this

$query = mysql_query("SELECT time,score  FROM statistics 
");
while($row = mysql_fetch_array($query)) {
  //then it would come like this
  //$row['field in database'];
}

If you however want it to be in a multi dimentional array, change the while to this

while($row = mysql_fetch_array($query)) {
  $data[] = $row;
}

[website]

$query=mysql_fetch_array(mysql_query("SELECT time,score FROM statistics
"));

Please do it for me, don't use this method of doing query, especially not in a while loop, it will go on forever, why?, because it will execute this line
$query=mysql_fetch_array(mysql_query("SELECT time,score FROM statistics"));
and it can always continue doing it, it is just a command, like if you would do while($test = print("stuff")) ...
Just please do it for me 😉, don't even try this, it will propably crash your computer..

[localhost]

yes you're right

but i still cant get this to work....

[website]

get what to work, what do you need?

[localhost]

solved...🙂

this is what i wanted

$data = array();
$query=mysql_query("SELECT time,score  FROM statistics 
");

while ($row=mysql_fetch_array($query)
{

$data[] = array("", $row['time'], $row['score']);

}

thanks for your attention😉

[website]

Ahh no problem but it is also easier just to do
while($row = mysql_fetch_array($query)) {
$data[] = $row;
}
Instead of that array() thing because $row already is an array 🙂

[localhost]

No,
i needed an array like this:

$data = array(
    array(  "", 2000,     750),
    array(  "", 2010,    1700),
    array(  "", 2015,    2000),
    array(  "", 2020,    1800),
    array(  "", 2025,    1300),
    array(  "", 2030,     400)
);

to draw a graphic

the last code that i posted is the one that i needed

thanks again for the inspiration🙂

[website]

well, it is almost the same...
now this is the same 🙂
while($row = mysql_fetch_array($query)) {
$data[] = array("") + $row;
}