Udvikleren.dk - Seneste [sum] forum tråde De seneste forum tråde i [sum] på Udvikleren.dk http://www.udvikleren.dk/ Wed, 29 Apr 2026 10:28:30 GMT http://backend.userland.com/rss Udvikleren.dk RSS Feeder 60 sortere efter id OG samlet pointsum? http://www.udvikleren.dk/forum/42896/sortere-efter-id-og-samlet-pointsum/ Sun, 30 Mar 2014 20:46:24 GMT PHP Math SUM af en MySQL return Har lige lavet en test på det jeg vil lave.<br /><br />Hvis nu min tabel "tal" returnere 10 forskellige. Hvordan får jeg så summen af alle $number?<br /><br /><div class="codeboxheader" id="code_1924267741" onclick="ToggleCodeBox(this.id);"><img id="code_1924267741_arrow" src="/images/icons/codeboxarrow_down.gif" alt="Fold kodeboks ind/ud" title="Fold kodeboks ind/ud" />PHP kode&nbsp;</div><pre id="code_1924267741code" style="border-top: 0px; display: none;"><ol><li style="padding: 0; margin: 0;"> <span style="color: #800080;">$query</span><span style="color: #000000;"> </span><span style="color: #000000;">=</span><span style="color: #000000;"> </span><span style="color: #008080;">mysql_query</span><span style="color: #000000;">(</span><span style="color: #000000;">&quot;</span><span style="color: #000000;">SELECT * FROM tal where</span><span style="color: #000000;">&quot;</span><span style="color: #000000;">) or </span><span style="color: #0000FF;">die</span><span style="color: #000000;">(</span><span style="color: #008080;">mysql_error</span><span style="color: #000000;">()); </span></li><li style="padding: 0; margin: 0;"> <span style="color: #000000;"></span><span style="color: #0000FF;">while</span><span style="color: #000000;">(</span><span style="color: #800080;">$row</span><span style="color: #000000;"> </span><span style="color: #000000;">=</span><span style="color: #000000;"> </span><span style="color: #008080;">mysql_fetch_array</span><span style="color: #000000;">( </span><span style="color: #800080;">$query</span><span style="color: #000000;"> )) { </span></li><li style="padding: 0; margin: 0;"> <span style="color: #000000;"></span><span style="color: #800080;">$firstnumber</span><span style="color: #000000;"> </span><span style="color: #000000;">=</span><span style="color: #000000;"> </span><span style="color: #800080;">$row</span><span style="color: #000000;">[</span><span style="color: #000000;">'</span><span style="color: #000000;">firstnumber</span><span style="color: #000000;">'</span><span style="color: #000000;">]; </span></li><li style="padding: 0; margin: 0;"> <span style="color: #000000;"></span><span style="color: #800080;">$secondnumber</span><span style="color: #000000;"> </span><span style="color: #000000;">=</span><span style="color: #000000;"> </span><span style="color: #800080;">$row</span><span style="color: #000000;">[</span><span style="color: #000000;">'</span><span style="color: #000000;">secondnumber</span><span style="color: #000000;">'</span><span style="color: #000000;">]; </span></li><li style="padding: 0; margin: 0;"> <span style="color: #000000;"></span><span style="color: #800080;">$number</span><span style="color: #000000;"> </span><span style="color: #000000;">=</span><span style="color: #000000;"> (</span><span style="color: #800080;">$firstnumber</span><span style="color: #000000;">+</span><span style="color: #800080;">$secondbumer</span><span style="color: #000000;">); </span></li><li style="padding: 0; margin: 0;"> <span style="color: #000000;">}</span></li></ol></pre><br /> http://www.udvikleren.dk/forum/36139/php-math-sum-af-en-mysql-return/ Wed, 07 Dec 2011 09:35:19 GMT