Jump to content

Archived

This topic is now archived and is closed to further replies.

kopander

sql data into an array

Recommended Posts

Hi, new to this. Wondering if it is possible to enter figures from a mysql database into an array, which can be used on php functions? Example: so I have a function such as:
[code]for ($i=0; $i<count($Values); $i++){ if ($Values[$i]>$max){$max=$Values[$i];} }[/code]
Which gets the values from a fixed array:
[code]$Values=array(120,190,130,155,150);[/code]

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 without changing the functions.

I was wondering if there is a way to get the data from the database, and write it into an array so that it will be the same as a variable, i.e I get something like:
[code]$Values=array(120,190,130,155,150,.......);[/code]
which can be used by the current fuctions.

Make any sense ???

Share this post


Link to post
Share on other sites
MySQL has a a MAX() function to do this for you. If you still need to get the data into an array, see the tutorials on working with MySQL here.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.