[RESOLVED] Do something every x records...

[benhodgson]

I have the following piece of code, designed for the print-out of ID cards for a member system.

$query="SELECT * FROM memb WHERE id_printed='0'";
$result=mysql_query($query) or die("<strong>Error ".mysql_errno().":</strong><br> ".mysql_error()."<br><br>\nQuery: $query");

$num=mysql_numrows($result);
mysql_close();

$i=0;
while ($i < $num) {

$id=mysql_result($result,$i,"id");
$first=mysql_result($result,$i,"first_name");
$last=mysql_result($result,$i,"surname");
$exec_pos=mysql_result($result,$i,"exec_pos");
$day=mysql_result($result,$i,"joined_day");
$month=mysql_result($result,$i,"joined_month");
$year=mysql_result($result,$i,"joined_year");
$image=mysql_result($result,$i,"image");

if(empty($image)){
	$image = "http://www.demonfm.co.uk/images/members/membphotos/nophoto.gif";
}

if (!($exec_pos=='') && !($exec_pos=='None') && !($exec_pos=='none'))
{
echo "
<div class=\"idmem\">
	<div class=\"extimg\">
		<img src=\"name.png\" alt=\"name\" />
	</div>
	<div class=\"fbg\">
		<img src=\"fbg.png\" alt=\"fieldbg\" />
	</div>
	<div class=\"fname\">
		<span class=\"text\">$first $last</span>
	</div>
	<div class=\"extimg\">
		<img src=\"valid.png\" alt=\"validuntil\" />
	</div>
	<div class=\"fbg\">
		<img src=\"fbg.png\" alt=\"fieldbg\" />
	</div>
	<div class=\"fjoin\">
		<span class=\"text\">$day $month $year</span>
	</div>
	<div class=\"extimg\">
		<img src=\"exec.png\" alt=\"execpos\" />
	</div>
	<div class=\"fbg\">
		<img src=\"fbg.png\" alt=\"fieldbg\" />
	</div>
	<div class=\"fjoin\">
		<span class=\"text\">$exec_pos</span>
	</div>
	<div class=\"exfid\">
		<span class=\"id\">$id</span>
	</div>
	<div class=\"exfpic\">
		<img src=\"$image\" width=\"99\" height=\"128\" alt=\"memberpic\" /><br />
		<img class=\"logo\" src=\"logo.png\" alt=\"demonlogo\" />
	</div>
</div>
";
}
else
{
echo "
<div class=\"idmem\">
	<div class=\"timg\">
		<img src=\"name.png\" alt=\"name\" />
	</div>
	<div class=\"fbg\">
		<img src=\"fbg.png\" alt=\"fieldbg\" />
	</div>
	<div class=\"fname\">
		<span class=\"text\">$first $last</span>
	</div>
	<div class=\"timg\">
		<img src=\"valid.png\" alt=\"validuntil\" />
	</div>
	<div class=\"fbg\">
		<img src=\"fbg.png\" alt=\"fieldbg\" />
	</div>
	<div class=\"fjoin\">
		<span class=\"text\">$day $month $year</span>
	</div>
	<div class=\"fid\">
		<span class=\"id\">$id</span>
	</div>
	<div class=\"fpic\">
		<img src=\"$image\" width=\"99\" height=\"128\" alt=\"memberpic\" /><br />
		<img class=\"logo\" src=\"logo.png\" alt=\"demonlogo\" />
	</div>
</div>
";
}

$i++;
}

8 cards will fit onto a single A4 sheet of paper. The problem is that the next two cards then span across two sheets, cutting them in half.

Is there any way to 'do something' (eg. Insert a blank space, probably as an image or empty DIV) every 8 records to push the next two cards down to the next page and, based on the code above, what would be the easiest way to do this?

Thanks in advance.

[Installer]

You already have a counter in your loop ($i). Use that to determine every 8th line:

$i=0;
while ($i < $num) {
    if (!($i % 8) && ($i != 0)) {
        // 'do something' (eg. Insert a blank space, probably as an image or empty DIV)
    }
    // rest of while loop

[benhodgson]

Thanks 🙂

[Weedpacket]

"Do something" could include adding a page break property to indicate - well, a page break.

[cheerio]

can't you also do something like this:

$sql = mysql_query("YOUR QUERY");
$i = 0;
while($row = mysql_fetch_array($sql))
{
  if($i % 8 == 1)
  {
    //Every eighth row
  }
  else
  {
    //Non 8th rows
  }
}

[Weedpacket]

Yes, you can (except that ($i%8==1) is wrong); but it would no doubt mean duplicating a lot of code in both branches, and why would you want to do that?