tables in a loop

seby

wow this is busting my brain.

i want to display images in rows of three from a query result.
so i have:

<tr>
<td width="33%">image1</td>
<td width="33%">image2</td>
<td width="34%">image3</td>
</tr>

etc...

but how do get the images to go across?
i feel like an idiot because i cant figure this out.

amcgrath

Seby,

Unless I'm misunderstadning, you are doing this correctly (assuming you are looping over the html. Let me know if that's the case.

amc

seby

you dont follow me.

i want to do this dynamically from a mysql query loop.. how do i automatically make it add a

<td width="33%"> </td>

but keeping three images per row?

stolzyboy

just did this quick and dirty, not really clean depending on number of results, but it works and should give you an idea on what you need to do

<?
$conn = mysql_connect('localhost', "xxxx", "xxxxxxx") or die("Could not connect to mysql");
$db = mysql_select_db("db") or die("Could not connect to database");

$query = "select * from table;";
$result = mysql_query($query) or die(mysql_error());

$i = 1;
?>
<table border="0" width="600">
<tr>
<?
while ($row =  mysql_fetch_array($result))
{
if ($i < 4)
{
?>
<td width="33%"><img src="<? echo $row['fieldnameforpic']; ?>"></td>
<?
$i++;
}
else
{
?>
</tr>
<tr>
<td width="33%"><img src="<? echo $row['fieldnameforpic']; ?>"></td>
<?
$i = 2;
}
}
?>
</tr>
</table>

amcgrath

OK, now I understand what you mean. The post above is pretty much correct, you can also use the fmod() function to determine if you need to spit out the closing/opening <tr> . Lastly, keep in mind that if you have an odd result set (odd based on the number 3, that is, like say 5) you'll need to account for it and keep the html clean. Hope that helps.

amc

stolzyboy

Originally posted by amcgrath
OK, now I understand what you mean. The post above is pretty much correct, you can also use the fmod() function to determine if you need to spit out the closing/opening <tr> . Lastly, keep in mind that if you have an odd result set (odd based on the number 3, that is, like say 5) you'll need to account for it and keep the html clean. Hope that helps.

amc

yep, that's why i said quick and dirty, i am hoping it will get him started, then he can clean it up as he needs, and he should, cuz it would only really work with results that are a multiple of three, i didn't feel the need to get that in depth, leaving him some extra programming work to do that will help him in the long run.