Reply to thread

Message

<blockquote data-quote="oxuwazet" data-source="post: 453112" data-attributes="member: 88455">Kinda hard to spot errors with improper code indentation and missing start tags.From looking at it is because you put that code in a while loop. So its looping that code so 19 results times how ever times the while loop goes. To clear it up is some rows show up as 7 is because with 19 results it leaves one on a row by its self then returns the whole loop and the loop shows 6 more results so ultimately showing 7.Here is how you should implement it.[PHP]&lt;?php// your code here.// the number of results.$noof = sqlsrv_num_rows($stmt);// the number of results in a row.$ross = 6;// start tables logic.echo &quot;&lt;tr&gt;\n&quot;;$i = 0;while ($row = sqlsrv_fetch_array($stmt, SQLSRV_FETCH_ASSOC)) {&nbsp; &nbsp; $i++;&nbsp; &nbsp; if ($i % $ross == 0) {&nbsp; &nbsp; &nbsp; &nbsp; output_row_data($row);&nbsp; &nbsp; &nbsp; &nbsp; echo &quot;&lt;/tr&gt;\n&quot;;&nbsp; &nbsp; &nbsp; &nbsp; if (!($noof - 1 &lt; $i)) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo &quot;&lt;tr&gt;\n&quot;;&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; } else {&nbsp; &nbsp; &nbsp; &nbsp; output_row_data($row);&nbsp; &nbsp; }}if (!($i % $ross == 0)) {&nbsp; &nbsp; echo &quot;&lt;/tr&gt;\n&quot;;}// end tables logic.// make the output row data function.function output_row_data(array $row){&nbsp; &nbsp; // out your row data.}?&gt;[/PHP]</blockquote>

[QUOTE="oxuwazet, post: 453112, member: 88455"] Kinda hard to spot errors with improper code indentation and missing start tags. From looking at it is because you put that code in a while loop. So its looping that code so 19 results times how ever times the while loop goes. To clear it up is some rows show up as 7 is because with 19 results it leaves one on a row by its self then returns the whole loop and the loop shows 6 more results so ultimately showing 7. Here is how you should implement it. [PHP]<?php // your code here. // the number of results. $noof = sqlsrv_num_rows($stmt); // the number of results in a row. $ross = 6; // start tables logic. echo "<tr>\n"; $i = 0; while ($row = sqlsrv_fetch_array($stmt, SQLSRV_FETCH_ASSOC)) { $i++; if ($i % $ross == 0) { output_row_data($row); echo "</tr>\n"; if (!($noof - 1 < $i)) { echo "<tr>\n"; } } else { output_row_data($row); } } if (!($i % $ross == 0)) { echo "</tr>\n"; } // end tables logic. // make the output row data function. function output_row_data(array $row) { // out your row data. } ?>[/PHP] [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members