MYSQL Displaying Rows

Anon

Hi, I am pretty new to PHP and mySQL just trying to figure out how to display some rows. Let's say in 1 table I have 40 rows I don't want to display them all vertically I want to be able to divide them up into columns. Let's say 4 columns that should give me 10 per column. So what I need is some kind of way to display 4 records then go down to the next line and display 4 more and so on until there are no more records left to display. By the way i only need to display 1 field of the record I don't know if that makes a difference. What I am trying to accomplish is to list certain category's a user can click on. Now I could create all those manually and format the table the way I want but I want my page to be as dynamic as possible so it will be easy to update. Can anyone help me with this. I am sure that this is a simple problem I just can't seem to figure it out.

bretticus

I think modulus (%) is your new friend ;-)

<table>
<tr>
<?
while($row = mysql_fetch_row($result)){
print "<td>$row[0]</td>";
$count++;
if($count%4 == 0){
print "</tr>";
}
}
?>
</tr>
</table>

Probably there's a bit more logic and tweaking to get the best dynamic output but I hope this gives you an idea at least

Anon

I assume you know how to get the records and stuff, but you have problems displaying the 4x10 table, right?

If so, then it's simple: Make a counter to count the number of fields currently displayed. If the count is a multiple of 4, then the next record should go in the next line, right?

So the code would look something like this:

$count = mysql_num_rows($result);
print "<table><tr>";
for ($i=1; $i<=$count; $i++) {
$row = mysql_fetch_array($result);
print "<td>" . $row[0] . "</td>";
if ($i % 4 == 0) print "</tr><tr>";
}
print "</tr></table>";

Diego

bretticus

whoops, missed a tiny little <tr>

<table>
<tr>
<?
while($row = mysql_fetch_row($result)){
print "<td>$row[0]</td>";
$count++;
if($count%4 == 0){
print "</tr><tr>";
}
}
?>
</tr>
</table>

But Diego had ya covered anyway ;-)

eojlin

read my post in this forum... i posted it a couple of hours ago. look for this topic "Gurus, Variable Function Arguments???" in this forum.
i have there a snippet that allows you to retrieve records dynamicaly and returns your result in a string, $strDisplay. to output your table, you could just echo $strDisplay.
i'm still working on it and i plan to release it to other programmers for enhancements.