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?
Hi.. I was needing some help also.. 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.. any help please.. this is what i have...
$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);