[SOLVED] echo 5 images and then a br

[only one]

how can i get it to echo 5 images and then a br

 

i was trying this code:

 

<?php
for ($i=0; $i<1; $i++) 
{
if ($i < 1) 
{
$query = mysql_query("SELECT * FROM `image_gallery` ORDER BY id DESC");
while ($row = mysql_fetch_array($query)) 
{
$i++;
echo "<img src='$row[image_url]' height='100' width='100'>"; 
}
}else{
echo "<br />";
}
?>

 

it didnt seem to work.. anyone got any ideas?

[kalivos]

I think this is what you were trying to do....

 

for ($i=0; $i<=5; $i++) 
{

echo "<br />";

 

However, a more "correct" way of doing it would be:

$query = mysql_query("SELECT * FROM `image_gallery` ORDER BY RAND() LIMIT 5");
     while ($row = mysql_fetch_array($query)) 
     {
          echo "<img src='$row[image_url]' height='100' width='100'>"; 
     }
}

echo "<br />";

 

Hope that helps,

-Kalivos

[only one]

maybe i didnt make myself clear, what i was trying to use that code too do was count to 5, then when it reaches 5 it echos a br and counts another five

 

so it will echo all my images in the database with 5 images per row..

[corbin]

This should work:

 

$query = mssql_query("SELECT * FROM image_gallery");
$i = 1;
while($r = mysql_fetch_assoc($query)) {
echo '<img src="'.$r['image_url'].'">';
if($i % 5 == 0) {
echo "<br />";
}
$i++;
}

[only one]

This should work:

 

$query = mssql_query("SELECT * FROM image_gallery");
$i = 1;
while($r = mysql_fetch_assoc($query)) {
echo '<img src="'.$r['image_url'].'">';
if($i % 5 == 0) {
echo "<br />";
}
$i++;
}

 

thanks that did the job