t_machine Posted March 4, 2006 Share Posted March 4, 2006 hi, I would like to display my database result in a table but only two per row. I am using a while loop so my query looks like the followingwhile($row ........I would like it to work like this<tr><td>item 1 </td> <td> item 2</td></tr><tr><td>item 3</td> <td> item 4</td></tr>See how after two colums it starts another row to display the next two results? How can this be done. Thanks :) Quote Link to comment Share on other sites More sharing options...
obsidian Posted March 4, 2006 Share Posted March 4, 2006 [code]$itemsPerRow = 2;$count = 0;while($row = mysql_fetch_array($sql)) { if ($count % $itemsPerRow == 0) echo "<tr>\n"; $count++; echo "<td>$row[whatever]</td>\n"; if ($count % $itemsPerRow == 0) echo "</tr>\n";}[/code]hope this helps! Quote Link to comment Share on other sites More sharing options...
t_machine Posted March 4, 2006 Author Share Posted March 4, 2006 Thank you very much :) This works perfectly Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.