idos Posted August 22, 2006 Share Posted August 22, 2006 I'm making a script where i want to multiply from 2 columns in a mySQL database and sum the product.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 db3 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 good5 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] Link to comment https://forums.phpfreaks.com/topic/18310-getting-the-product-from-2-arrays/ Share on other sites More sharing options...
hitman6003 Posted August 22, 2006 Share Posted August 22, 2006 Either of these two should work for you:[code]$grad = array($row['Grad']);$bestigning = array($row['Bestigning']);$score = $grad[0] * $bestigning[0];echo $score;$score = array($row['Grad'], $row['Bestigning']);echo(array_product($score));[/code] Link to comment https://forums.phpfreaks.com/topic/18310-getting-the-product-from-2-arrays/#findComment-78648 Share on other sites More sharing options...
idos Posted August 24, 2006 Author Share Posted August 24, 2006 Hmm well i still can't get it to work.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:[quote][code=php:0][code=php:0]$sql = 'SELECT SUM(score) FROM `ruter` WHERE Navn = \'"username"\' ORDER BY `Grad` LIMIT 0,20';[/code][/quote]So my question is: How can i display the SUM(score) result from the database... Link to comment https://forums.phpfreaks.com/topic/18310-getting-the-product-from-2-arrays/#findComment-79923 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.