如果页面上只有2行，则添加中断

Question

I need to add line break like </div> to end if only 2 rows on PAGE (not every 2 rows) (not in mysql).

My Code:

$results_per_page = 12;
if (isset($_GET["page"])) { $page  = $_GET["page"]; } else { $page=1; }; 
$start_from = ($page-1) * $results_per_page;
$sth = $db->prepare("SELECT * FROM users WHERE active='1' ORDER BY vip DESC, date DESC LIMIT $start_from, ".$results_per_page);
$sth->execute();
while($answer=$sth->fetch()){ if (only 2 rows on PAGE) { blabla } }

Answer 1

Just use

$sth = $db->prepare("SELECT * FROM users WHERE active='1' ORDER BY vip DESC, date DESC LIMIT $start_from, ".$results_per_page);
$sth->execute();

// better to get result in variable
$result = $sth->fetchAll();

if (count($result) == 2) {
   echo '</div>';
}

// to display rows
foreach($result as $row) {
    // $row is array, it contains your columns
    echo $row['content'];
}