news system with adodb

[Benpsycho]

Hi,

I am creating a news system with php and try to use the functions PageExecute and Move from adodb for it. Are there any examples of how to use those functions or any tips how to work with them.

I would really appreciate it if someone could tell me how to start of with those functions..

Thx

[Benpsycho]

Well I gave it a shot and failed..

What's wrong with this code?

$rs = $db->PageExecute('Select newsid,title,text,time FROM news ORDER BY time', 3, $news['page']);
//If page too high get last possible page

//Check if no news exist
if ($rs->EOF() && ($rs->AtFirstPage() || $rs->AtLastPage())) print_error("No News");
elseif($rs->EOF()) print_error("Not a valid newspage");

//News navigation items

$news['next'] = $db->AbsolutePage() + 1;
$news['AtFirstPage'] = $db->AtFirstPage();
$news['previous'] = $db->AbsolutePage() - 1;
$news['AtLastPage'] = $db->AtLastPage();
$news['LastPage'] = $rs->LastPageNo();