De seneste forum tråde i [round] på Udvikleren.dk http://www.udvikleren.dk/ Tue, 28 Apr 2026 15:31:04 GMT http://backend.userland.com/rss Udvikleren.dk RSS Feeder 60 Jeg har denne MySQLI query :<br /><div class="codeboxheader" id="code_1651283558" onclick="ToggleCodeBox(this.id);"><img id="code_1651283558_arrow" src="/images/icons/codeboxarrow_down.gif" alt="Fold kodeboks ind/ud" title="Fold kodeboks ind/ud" />SQL kode&nbsp;</div><pre id="code_1651283558code" style="border-top: 0px; display: none;"><ol><li style="padding: 0; margin: 0;"> <span style="color: #000000;">$asdasdas </span><span style="color: #808080;">=</span><span style="color: #000000;"> $db</span><span style="color: #808080;">-&gt;</span><span style="color: #0000FF;">prepare</span><span style="color: #000000;">(&quot;</span><span style="color: #0000FF;">UPDATE</span><span style="color: #000000;"> $tablenavn </span><span style="color: #0000FF;">SET</span><span style="color: #000000;"> totalrating</span><span style="color: #808080;">=</span><span style="color: #000000;">totalrating</span><span style="color: #808080;">+</span><span style="color: #000000;">?, </span><span style="color: #FF00FF;">count</span><span style="color: #808080;">=</span><span style="color: #FF00FF;">count</span><span style="color: #808080;">+</span><span style="color: #800000; font-weight: bold;">1</span><span style="color: #000000;"> </span><span style="color: #0000FF;">WHERE</span><span style="color: #000000;"> gennemsnit</span><span style="color: #808080;">=</span><span style="color: #000000;">? </span><span style="color: #808080;">AND</span><span style="color: #000000;"> url</span><span style="color: #808080;">=</span><span style="color: #000000;">? </span><span style="color: #808080;">AND</span><span style="color: #000000;"> users_ip</span><span style="color: #808080;">=</span><span style="color: #000000;">?&quot;); </span></li><li style="padding: 0; margin: 0;"> <span style="color: #000000;">$asdasdas</span><span style="color: #808080;">-&gt;</span><span style="color: #000000;">bind_param(</span><span style="color: #FF0000;">'</span><span style="color: #FF0000;">idss</span><span style="color: #FF0000;">'</span><span style="color: #000000;">, $rating, $gennemsnit, $url, $users_ip);</span></li></ol></pre><br /><br />Er det muligt at tage de nye værdier af totalrating og count også udregne et gennemsnit.<br /><br />Måske noget i denne stil.<br /><div class="codeboxheader" id="code_1135761274" onclick="ToggleCodeBox(this.id);"><img id="code_1135761274_arrow" src="/images/icons/codeboxarrow_down.gif" alt="Fold kodeboks ind/ud" title="Fold kodeboks ind/ud" />SQL kode&nbsp;</div><pre id="code_1135761274code" style="border-top: 0px; display: none;"><ol><li style="padding: 0; margin: 0;"> <span style="color: #000000;">$asdasdas </span><span style="color: #808080;">=</span><span style="color: #000000;"> $db</span><span style="color: #808080;">-&gt;</span><span style="color: #0000FF;">prepare</span><span style="color: #000000;">(&quot;</span><span style="color: #0000FF;">UPDATE</span><span style="color: #000000;"> $tablenavn </span><span style="color: #0000FF;">SET</span><span style="color: #000000;"> totalrating</span><span style="color: #808080;">=</span><span style="color: #000000;">totalrating</span><span style="color: #808080;">+</span><span style="color: #000000;">?, </span><span style="color: #FF00FF;">count</span><span style="color: #808080;">=</span><span style="color: #FF00FF;">count</span><span style="color: #808080;">+</span><span style="color: #800000; font-weight: bold;">1</span><span style="color: #000000;"> </span><span style="color: #0000FF;">WHERE</span><span style="color: #000000;"> gennemsnit</span><span style="color: #808080;">=</span><span style="color: #FF00FF;">round</span><span style="color: #000000;">(total </span><span style="color: #808080;">/</span><span style="color: #000000;"> </span><span style="color: #FF00FF;">count</span><span style="color: #000000;">, </span><span style="color: #800000; font-weight: bold;">1</span><span style="color: #000000;">) </span><span style="color: #808080;">AND</span><span style="color: #000000;"> url</span><span style="color: #808080;">=</span><span style="color: #000000;">? </span><span style="color: #808080;">AND</span><span style="color: #000000;"> users_ip</span><span style="color: #808080;">=</span><span style="color: #000000;">?&quot;); </span></li><li style="padding: 0; margin: 0;"> <span style="color: #000000;">$asdasdas</span><span style="color: #808080;">-&gt;</span><span style="color: #000000;">bind_param(</span><span style="color: #FF0000;">'</span><span style="color: #FF0000;">idss</span><span style="color: #FF0000;">'</span><span style="color: #000000;">, $rating, $gennemsnit, $url, $users_ip);</span></li></ol></pre><br /> http://www.udvikleren.dk/forum/39480/afrund-til-i-query/ Wed, 23 Jan 2013 17:29:50 GMT