Looping through data in sections

mdm1001

I have a mySql query returns 50 results. Is there a way to move the loop in sections.
I need to create 4 tables of data in four CSS columns. As you can see in my code i can loop through the 1st 13 records no problem.
What I need to do is start the next table with the 14th record. Thanks,

<!-- Column one start -->
<?
echo "<center>";
echo "<table>";
	echo "<tr>"; 
	include('config.php'); 
		$result = mysql_query("SELECT * FROM `state`") or trigger_error(mysql_error()); 
		$count = 0;
			while( $count < 13 && $row = mysql_fetch_array($result)){ 
			foreach($row AS $key => $value) { $row[$key] = stripslashes($value); } 

		echo "<td><a href=aCity.php?state_id={$row['state_id']}>" . nl2br( $row['state']) . "</a></td>";
		echo "</tr>"; 
		$count = $count + 1;
	} 

	echo "</table>";
	echo "</center>";				
	?>
<!-- Column one end -->

bradgrafelman

So... what have you tried? Sounds like all you need to do is copy the PHP code beginning with the $count assignment station (just before the while() loop) and ending after the end of the while() loop, paste that in the appropriate location, and update the HTML markup as appropriate.

mdm1001

The worked thank you for your help. Here is my final solution.

					<!-- Column one start -->
						<?
						echo "<center>";
						echo "<table>";
						echo "<tr>"; 
							include('config.php'); 
							$result = mysql_query("SELECT * FROM `state`") or trigger_error(mysql_error()); 
							$count = 0;
							while( $count < 13 && $row = mysql_fetch_array($result)){ 
							foreach($row AS $key => $value) { $row[$key] = stripslashes($value); } 

					echo "<td><a href=aCity.php?state_id={$row['state_id']}>" . nl2br( $row['state']) . "</a></td>";
					echo "</tr>"; 
					$count = $count + 1;
					} 

					echo "</table>";
					echo "</center>";				
					?>
				<!-- Column one end -->
			</div>
			<div id="col2">
				<!-- Column two start -->
					<?
					echo "<center>";
					echo "<table>";
					echo "<tr>"; 
						while( $count < 26 && $row = mysql_fetch_array($result)){ 
						foreach($row AS $key => $value) { $row[$key] = stripslashes($value); } 

					echo "<td><a href=aCity.php?state_id={$row['state_id']}>" . nl2br( $row['state']) . "</a></td>";
					echo "</tr>"; 
					$count = $count + 1;
					} 

					echo "</table>";
					echo "</center>";				
					?>
				<!-- Column two end -->
			</div>

bradgrafelman

Note one other issue I see with your code: You should never have to apply [man]stripslashes/man to the data coming from your SQL database. If that data contains superfluous backslashes, then the problem is that you're not inserting the data correctly in the first place.

m_tt

Wouldn't that code produce tables of 1-13, then 1-26 (instead of 14-26)?

Weedpacket

m@tt wrote:

Wouldn't that code produce tables of 1-13, then 1-26 (instead of 14-26)?

No, because neither [font=monospace]$count[/font] nor the result set are reset.

Personally, instead of duplicating a big chunk of code, I would have read all of the rows into an array used [man]array_chunk[/man], and then looped over the result - but I'd be assuming memory isn't an issue.

m_tt

I agree with not duplicating the code. Wouldn't something as simple as this work for what he needs?

$count = 1;
while($row = mysql_fetch_array($result)) {
	// Build rows
	if ($count % 13 === 0) {
		// Break tables
		echo "</table><table>";
	}
	$count++;
}