Ah - OK!
I tried this but it is not updating the advert_views - so I am missing the proper binding or the increment function..
<?php
$rsAdverts = new WA_MySQLi_RS("rsAdverts",$mysqli2,1);
$rsAdverts->setQuery("SELECT * FROM adverts WHERE adverts.advert_activate = '1' ORDER BY RAND ()");
$rsAdverts->execute();?>
<?php
if ("" === "") {
$UpdateQuery = new WA_MySQLi_Query($mysqli2);
$UpdateQuery->Action = "update";
$UpdateQuery->Table = "adverts";
$UpdateQuery->bindColumn("advert_views", "i", "1", "WA_DEFAULT");
$UpdateQuery->addFilter("advert_id", "=", "i", "".($_GET['advert_id']) ."");
$UpdateQuery->execute();
$UpdateGoTo = "";
if (function_exists("rel2abs")) $UpdateGoTo = $UpdateGoTo?rel2abs($UpdateGoTo,dirname(__FILE__)):"";
$UpdateQuery->redirect($UpdateGoTo);
}
?>
Thanks