[RESOLVED] php out: when <td> equal 3, then make new <tr>

[ATS16805]

i got this idea from a ColdFusion tutorial i completed a Long while ago. haha-- my take on it is still there if you want to see the example of what it's does-- precisely what i want here, well-- i think i want this-- there's probably a better way to do it so the screen is less cluttered-- by allowing for multiple page views or something of that nature, but i'll start simple.

the idea is that as the array (a while loop would be fine) loops to echo the output to the screen, upon reaching every 4th (or 5th, etc-- doesn't matter) row, or new array key, that <tr> is closed, and a new <tr> is begun, thereby creating a "nice, neat" table grid, filled w/ all of the database entries. the ColdFusion code looks like this, and i want to do the same thing, if possible, w/ PHP (i've cut out the fat, showing only the part that makes the new rows):

<cfoutput query="concert_recordset">
<cfif concert_recordset.currentrow mod 3 eq 1>
<td><tr>
</cfif>
<td>
...snip...
</td>
<cfif concert_recordset.currentrow mod 3 eq 0>
<td>
</tr>
</cfif>

of course, i realize this isn't a ColdFusion forum, but i imagine even if you've never used the language, you can get the idea just from my description, and from the example link, what PHP function i need to reference. i'm just looking for a link to the right PHP manual page. if i can't figure it out, then i'll come back form help. if no similar function exists, then do you have an idea? maybe you have a better idea altogether to get the "same effect"?

thanks so much!

edit: btw, this has Nothing to do w/ that concert scheduler i've been working on-- this is something completely different, and much more simple. i just want to spit out records of contact info collection. row number, and first name to protect privacy- for purpose of showing "approximate interest" in a forthcoming seminar event for which i'm gathering mailing listi info. i want to allow visitors to click to see how many other people have already signed up.

[slweb]

This is my PHP/mySQLversion, you may be able to hack it a bit, Its using phps count()

<?php
        //SQL QUERY TO SELECT ALL OF THE USERS
	$sql2 = "SELECT * FROM photos ORDER by id ASC";
	$sql2 = mysql_query($sql2);
	$n = 1;
	$x = 2; //TD's accross page.
	//WHILE USERS ARE IN THE DATABASE DO THE FOLLOWING
	while($result2 = mysql_fetch_assoc($sql2)) {

?>

      <td align="center">
       <img src="images/<?php print($result2['photo']); ?>" border="0" width="201px" alt="">
        <br><?php print($result2['discription']); ?>
<? 
					if($n == $x) { 
						$y = ($x + 2);
						$x = $y;
						echo("</td></tr><tr>");
					}
				?>


      <? if($n != $x) { echo("</td>"); ?>
<?php
	}

$n++;
//END WHILE
}
?>

[bpat1434]

While the above post will work, the following is a much simpler way to do it.

// Do mySQL query here.
// mySQL results held in $result variable

$i = 1;
while($row = mysql_fetch_array($result)){
    echo '<td>'.$some_information.'</td>';
    if($i%3 == 0){
        echo '</tr><tr>';
    }
    $i++;
}
// Put on the last row ender
if($i%3 != 0){
    echo '</tr>';
}

Basically, create a variable that increments each time you loop through the information. Then use the modulous operator to see if there is a remainder when the variable ($i) is divided by 3. If no remainder (3,6,9,12) then end the row, and begin a new one; otherwise, don't end the row.

~Brett

[ATS16805]

d@mn@! that was fast!!! thanks!
😃

[ATS16805]

bpat1434, i just wanted to say that your proposed code worked PERFECTLY, as i'm sure you knew it would. that will be something that i'll get a lot of mileage out of. thank's very much.
slweb, i tried the other first, so i didn't dissect your proposal. but, thank you just the same. almost never do i go away from phpbuilder.com disappointed. there's just so much good help here, and good people helping out. thanks!

[bpat1434]

Glad we could be of service yet again...

Don't forget to mark this resolved
Thread Tools --> Mark Resolved

~Brett

[ATS16805]

oops-- sorry-- i always forget to mark resolved! my apologies. i know it helps to do it.