I need to print 5 title from my content table into two html <div>
. first, I print 2 title using php loops with LIMIT 2
:
$SQL = Access::FETCH("SELECT * FROM " . CONTENT . " WHERE active = ?, ORDER BY name LIMIT 2", 'YES');
foreach($SQL AS $row){
?>
<div class="levelOne"><?PHP echo $row['title']; ?></div>
<?PHP
}
?>
output:
TITLE 1
TITLE 5
Now I need to print 3 remaining title using php loops with LIMIT 3
:
$SQL = Access::FETCH("SELECT * FROM " . CONTENT . " WHERE active = ?, ORDER BY name LIMIT 3", 'YES');
foreach($SQL AS $row){
?>
<div class="levelTwo"><?PHP echo $row['title']; ?></div>
<?PHP
}
?>
output:
TITLE 1
TITLE 5
TITLE 7
This output is false(because title 1 and 5 is in first output So my second code is wrong).Now, Ho do print 3 remaining title like this output:
TITLE 7
TITLE 9
TITLE 11