getting the product from 2 arrays.
Posted 22 August 2006 - 04:26 PM
1 User submit values in a form (grade and accent style(in climbing)) (they see a string but the values are int.)
2 Theese values are stored in a db
3 i use a quiery to display them in a table but now and the numbers are converted to strings from an array.
4 i multiply the grade and the accentstyle integers and get the individual score the route produced..
so far so good
5 i now want to sum the individual route score to a scoretotal for each person, but so far i haven't managed to both multiply the 2 columns and sum them. i have tried to create a multidimentional array and use array_product($multidimarray) but with no luck so far...
can some one please help...
[attachment deleted by admin]
Posted 22 August 2006 - 04:46 PM
$grad = array($row['Grad']); $bestigning = array($row['Bestigning']); $score = $grad * $bestigning; echo $score; $score = array($row['Grad'], $row['Bestigning']); echo(array_product($score));
Posted 24 August 2006 - 04:51 PM
But i have altered the form and insert.php to insert the score in the database.
I can get the total score in MyPHPadmin using this quiery:
[code=php:0]$sql = 'SELECT SUM(score) FROM `ruter` WHERE Navn = \'"username"\' ORDER BY `Grad` LIMIT 0,20';
So my question is: How can i display the SUM(score) result from the database...
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users