One last one Jason.
How would I modify this mysqli rs:
<?php
$News = new WA_MySQLi_RS("News",$DBConnection,2);
$News->setQuery("SELECT * FROM news WHERE Live = 1 ORDER BY NewsOrder DESC");
$News->execute();
?>
to recreate the same function as this old style rs
<?php
mysql_select_db($database_PowerCMSConnection, $PowerCMSConnection);
$query_News = "SELECT * FROM news WHERE Live = 1 ORDER BY NewsDate ASC";
$News = mysql_query($query_News, $PowerCMSConnection) or die(mysql_error());
$row_News = mysql_fetch_assoc($News);
$totalRows_News = mysql_num_rows($News);
$queryString_News = "";
if (!empty($_SERVER['QUERY_STRING'])) {
$params = explode("&", $_SERVER['QUERY_STRING']);
$newParams = array();
foreach ($params as $param) {
if (stristr($param, "pageNum_News") == false &&
stristr($param, "totalRows_News") == false) {
array_push($newParams, $param);
}
}
if (count($newParams) != 0) {
$queryString_News = "&" . htmlentities(implode("&", $newParams));
}
}
$queryString_News = sprintf("&totalRows_News=%d%s", $totalRows_News, $queryString_News);
?>
many thanks
Jamie
