Limit 2, 4 not returning correct rows
The limit parameter works fine when testing in the server behavior, but is returning the wrong rows in the repeat on the page.
This should be returning records 3 through 6 correct? But I actually only get records 1 and 2. on the page. Testing within the Server Behavior dialog box returns the correct set.
<?php
$rsFeatures2 = new WA_MySQLi_RS("rsFeatures2",$nMedia3_i,2,4);
$rsFeatures2->setQuery("SELECT content1.contentID, content1.featureDate, content1.headline, content1.photo1, content1.caption1, content1.para1 FROM content1 ORDER BY content1.featureDate DESC");
$rsFeatures2->execute();
?>
<?php
while(!$rsFeatures2->atEnd()) {
?>
<div class="text-center marginBottom30">
<a href="content.php?contentID=<?php echo($rsFeatures2->getColumnVal("contentID")); ?>"><img class="featurePhoto" src="https://hotvws.com/images/hot_vws_articles/<?php echo($rsFeatures2->getColumnVal("contentID")); ?>/<?php echo($rsFeatures2->getColumnVal("photo1")); ?>" alt=""/></a>
<h3 class="marginTop10"><?php echo($rsFeatures2->getColumnVal("headline"));?></h3>
<p><?php echo (wordCutString($rsFeatures2->getColumnVal("para1")));?>... <a href="content.php?contentID=<?php echo($rsFeatures2->getColumnVal("contentID")); ?>">Read More</a></p>
</div>
<?php
$rsFeatures2->moveNext();
}
$rsFeatures2->moveFirst(); //return RS to first record
?> </div>
Thanks for any insight