mysql_query problems

[Anon]

I am querying my database for scores in a survey. I can pull the info required (see code below) and it returns a resultset if printed of the scores submitted. Great, but what i need to do is to be able to split the results.The scores returned are (actual out put in HTML) 76576. What im trying to do is to assign a variable for this output ie biscore = (output) and then i want to reference the scores separtately to flash ie bi1= biscore[0], bi2=biscore[1], bi3=biscore[2] etc. My flash movie requires a) the total array (biscore) and b) individual scores (bi1, bi2 etc. The next part is to add the total scores together and divide by the number of csores submitted so i can get an average score.Heres the code$result = mysql_query("SELECT importance FROM statement1 WHERE tarID=79326 AND status='boss' AND importance IS NOT NULL") or die("Could not complete database query");$num = mysql_num_rows($result);while($query_data = mysql_fetch_row($result)) {print "$query_data[0]";}?>
Any asistance would be greatly appreciated.

[Anon]

Code update:

$result = mysql_query("SELECT importance FROM statement1 WHERE tarID=79326 AND status='boss' AND importance IS NOT NULL")

or die("Could not complete database query");

$biscore_num = mysql_num_rows($result);

$output ="&biscore_num=$biscore_num";

for ($count = 0; $count < $biscore_num; $count++)
{

$biscore = mysql_fetch_row($result);
$bi = $biscore[0];

$output .="&bi$count=$biscore[0]";
}
$avbi = ($bi0 + $bi1 + $bi2 + $bi3 + $bi4 + $bi5 + $bi6 + $bi7 + $bi8) / $biscore_num;

$output .="&avbi=$avbi";

echo $output;

?>

The individual numbers are now available....but the $avbi (the average f the scores = 0?

Any ideas why?

andybrad

[herve]

Hi,

the $avbi (the average f the scores = 0?
Any ideas why?

yes :

How is computed the $avbi value ?
By adding $bi0 + $bi1 ... divided by
$biscore_num. Correct ?

But ... where in your code the $bi0,
$bi1, $bi2 are initialized ? (meaning
that $bi1, $bi2 haven\'t any value) ;
the line

$bi = $biscore[0]; 

doesn\'t help

What you need to do, it to do a sum
in your loop like that :

before the loop :
$my_sum = 0;

inside the loop :

   $my_sum = $my_sum + $biscore[0];

then, after the loop, compute the mean :

   $avbi = $my_sum / $biscore_num;

Hervé.

[Anon]

Do you mean like so???

$biscore_num = mysql_num_rows($result);

$output ="&biscore_num=$biscore_num";

$my_sum = 0;
for ($count = 0; $count < $biscore_num; $count++)
{

$biscore = mysql_fetch_row($result);
$bi = $biscore[0];
$my_sum = $my_sum + $biscore[0];

$output .="&bi$count=$biscore[0]";
}
$avbi = $my_sum / $biscore_num;

$output .="&avbi=$avbi";

echo $output;

?>

Is the syntax right?