array trouble

182x

Hey guys, I have been using the following code to put data from a query into the arrays as shown below.

However there will be some cases where the data will have to be calculated from the one or more queries and stored in an array before the while loop can be performed. So I was wondering how do you perform the same while loop but with the results stored in an array as the mysql_fetch_array would not work?

mysql_select_db("gra",$db) or die(mysql_error());
$query = mysql_query("SELECT name, count(*) FROM gra group by name") or die(mysql_error());

while($getData = mysql_fetch_array($query)){
	$points[] = $getData[1];
	$months[] = $getData[0];
}

laserlight

However there will be some cases where the data will have to be calculated from the one or more queries and stored in an array before the while loop can be performed. So I was wondering how do you perform the same while loop but with the results stored in an array as the mysql_fetch_array would not work?

What do you mean?

182x

sorry I wasn't clear, I have to achieve the same result as in the example I posted however in this case the data is extrated from the database first and has some calculations preformed on it before it is entered into the two arrays. I was wondering how to enter this information as I can't use the same while loop as the information is not comming directly from the database.

laserlight

in this case the data is extrated from the database first and has some calculations preformed on it before it is entered into the two arrays. I was wondering how to enter this information as I can't use the same while loop as the information is not comming directly from the database.

You can use the same while loop: just perform the calculations in the while loop and then append to the array(s).

182x

how does that work as you can't have $getData = mysql_fetch_array($query), getData2 = mysql_fetch_array($query2) in the same while loop?

laserlight

Actually, you can. Why not provide more details of the actual problem that you are trying to solve? Perhaps this could be combined into a single query.

182x

Thanks, im on another machine at the moment but as soon as I get back I will post the code that my help explain the problem better.