Here's my first MySQLi recordset:
<?php
$rsTOP5NEWS = new WA_MySQLi_RS("rsTOP5NEWS",$csdbmysqli,5);
$rsTOP5NEWS->setQuery("SELECT newsID, newsdate, newstitle, newssummary, newsdelete FROM news WHERE newsdelete = 2 ORDER BY newsdate DESC");
$rsTOP5NEWS->execute();?>
This returns the top 5 news items (by date).
So how should my second MySQLi recordset look?
Not being familiar with PHP I tried this without success...
<?php
$rsRESTOFNEWS = new WA_MySQLi_RS("rsRESTOFNEWS",$csdbmysqli,10);
$rsRESTOFNEWS->setQuery("SELECT newsID, newsdate, newstitle, newssummary, newsdelete FROM news WHERE newsdelete = 2 AND newsID NOT IN $rsTOP5NEWS ORDER BY newsdate DESC");
$rsRESTOFNEWS->execute();?>
Hope you can help. Thank you.
NJ