[RESOLVED] sql data into array

[kopander]

Is it possible to enter figures from a mysql database into an array, which can be used on php functions? For example, I need to get figures from a database into a form such as:

$Values=array(120,190,130,155,150);

so that I can use the array in functions such as:

for ($i=0; $i<count($Values); $i++){
  if ($Values[$i]>$max){$max=$Values[$i];}
}

What kind of things should I be looking at?

Thanks!

[bogu]

What do u mean by:

kopander wrote:

Is it possible to enter figures from a mysql database into an array

😕

[kopander]

Sorry, was trying to keep it short. I created fucntions such as

for ($i=0; $i<count($Values); $i++){
  if ($Values[$i]>$max){$max=$Values[$i];}
}

Using a fixed array:

$Values=array(120,190,130,155,150);

Now i'm trying to get the data from a database. But the problem I cant figure out how to change everything so it uses the data from the database. I was wondering if there was just a way to get the data from the database, and write it into an array so that it will be the same at variable

$Values=array(120,190,130,155,150,.......);

Make any sense? 😕

[benbox]

If I think I know what you mean, you'll need something like..

$sql = "SELECT * FROM table";
$query = mysql_query($sql);
while ($row = mysql_fetch_array($query)) {
     $Values[] = $row['field'];
}

That would take every returned field, and put it into an array called $Values like you have mentioned.. you can then sort $Values however you like.

This is actually similar to my question which I've just posted, but I somehow want 2 values in this at the same time.. multi-level array somehow for mine, but I'm confused on how to do it!

[kopander]

Thanks, thats done the trick!