for loop?

[Anon]

echo "<table border=1>";
echo "<tr>";
while($result = mysql_fetch_array($sql))
{
echo "<td><IMG SRC=\"$result[photo]\""></td>";
}
echo "</tr>";
echo "</table>";

so if there are 15 entries in the db, it gives me 15 cells in one row.

How can i limit the cells in a row to 4, and have it generate however many rows to display all.

I've been experimenting with for loops, but no luck.

[lawnmowerman]

You could change your while loop to read like this:

$count = 1;
while($result = mysql_fetch_array($sql))
{
if( $count++ == 4 ) {
print "</tr><tr>";
$count = 1;
}
echo "<td><IMG SRC=\"$result[photo]\""></td>";
}

The $count variable will keep track of how many cells have been displayed and end the current row and start a new row after 4 have been displayed.

-Rich

[cheald]

echo "<table border=1>";
echo "<tr>";
$i = 0;
while($result = mysql_fetch_array($sql))
{
$i++;
echo "<td><IMG SRC=\"$result[photo]\""></td>";
if($i == 4) {
echo "</TR><TR>\n";
$i=0;
}
}
echo "</tr>";
echo "</table>";

That'll do it for ya. Just change the i == x to however many rows you want.

Best regards,

Chris

[Anon]

You can use the mysql_num_rows() function to get the number of results the query returned. Then, divide that number by the number of cells you want (4?). Add one to that, and it will give you the number of rows to create... then just use a typical for loop:

for($i=0; $i < $rows; $i++) {
// Put your html here
}

You add one to it because if you don't, you'll lose any odd out results.

[Anon]

<?php
echo "<table border = 1 align = center><tr>";
$i=1;
while ($i <=100){
echo "<td> $i </td>";
if ($i%5 ==0){
echo "</tr><tr>";
}
$i++;
}
echo "</tr></table>";
?>

i think this also servers ur need

[lawnmowerman]

While using 'if( $i % 5 == 0 )' is perfectly valid, This will result in 5 columns, not 4.

Also, since the variable increment is in the else of that if() statement, the value will never increase above 5, but will stay 5 for each loop after it reaches 5.

-Rich

[Anon]

u can easily change 5 to 4 and i know rest of script works to ur wish

mandar

[lawnmowerman]

My mistake. With the poor formatting of the code (due to how the site displays code, not due to your code), I mis-read it.

You are correct.

Sorry,

-Rich