Page Break with Tables and MySQL

[crtech]

Hello I Found This I am retreaving my data from the MySQL database and display it inside HTML table. What I need to do is display every sixth row of the table on the new page (when user prints it). I know that it is possible with CSS if I do something like this: <tr style=\"page-break-after: always;\"> My problem is how can I make my code to insert this line (<tr style=\"page-break-after: always;\">) every sixth row? I tried to do the following but it doesn't really work correctly. Can anybody help?


. . .

$num_results = mysql_num_rows($result);

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

if($i%6==5){

echo"<tr style=\"page-break-after: always;\">"; }

else {

echo" <tr>"; }

. . .






The above is exactly what i need, and i can get the above code working but, my problem is it when it gets data from the data base it just keeps pulling the same row of data, I dont know how to make it move to the next row of data until all rows are displayed. I was playing around with while($row = mysql_fetch_row($result)) statement but no luck. any help please.. this is what i have...



<?php
include("conf.php");
$connection = mysql_connect($server, $user, $pass);
mysql_select_db($db) or die ("Unable to select database!");
$query = "SELECT * FROM users WHERE (status='Active')";
$result = mysql_query($query) or die ("Error in query: $query. ".mysql_error());
$row = mysql_fetch_row($result);

$num_results = 19;
for ($i=0; $i <$num_results; $i++) {
if($i%5==4){
echo "next<br>";
}
else {
echo "User:$row[3]>";
}
}

mysql_free_result($result);
mysql_close($connection);

?>

im sure its easy for someone that knows what their doing, im just now trying to learn php...

[Declan1991]

while ($row = mysql_fetch_row($result)) {
if($i%5==4){
echo "next<br>";
}
else {
echo "User:$row[3]>";
}
}
++$i;
}

[crtech]

That was it.. thanks a lot..