RE: [PEAR] DataGrid: problems with paging

Not sure what happened but this morning I came in and it worked ... Sorry to be dense what does PK stand for? Thanks, Mark >-----Original Message----- >From: Justin Patrin [mailto:papercrane@gmail.com] >Sent: Friday, November 18, 2005 9:37 PM >To: Mark Steudel >Cc: pear-general@lists.php.net >Subject: Re: [PEAR] DataGrid: problems with paging > >On 11/18/05, Mark Steudel <mark@netriver.net> wrote: >> I have 25 records in the tblMenu table, and I set it to show >5 records >> per page. When I get the paging, I only get 1 | 2 >> >> >> >> require('Structures/DataGrid.php'); >> >> $dg =& new Structures_DataGrid(5); >> >> // fetch menu data from db >> $res =& $db->query( "SELECT * FROM tblMenu" ); mysqlErrorCheck($res); >> > >Perhaps try a numRows() on your res to make sure it returns >25. Also, make sure your PK is set up correctly. > >> $dg->bind($res); >> >> // assign content to template >> $tpl->assign('content', $dg->renderer->toHTML($dg)); >> $tpl->assign('pagination', $dg->renderer->getPaging()) >> >> >> I also tried it this way, but I get "Undefined class name >> 'structures_datagrid_datasource'" >> >> >> require('Structures/DataGrid.php'); >> >> $dg =& new Structures_DataGrid(5); >> >> // fetch user data from db >> $res =& $db->query( "SELECT * FROM tblMenu" ); mysqlErrorCheck($res); >> >> $data = Structures_DataGrid_DataSource::create($res); >> $dg->bindDataSource($data); >> >> $dg->renderer->setTableHeaderAttributes(array('bgcolor' => >> '#4A497B')); >> $dg->renderer->setTableOddRowAttributes(array('bgcolor' >> => '#CCCCCC')); >> $dg->renderer->setTableEvenRowAttributes(array('bgcolor' => >> '#EEEEEE')); >> >> >> $dg->renderer->sortIconASC = "&uArr;"; >> $dg->renderer->sortIconDESC = >> "&dArr;"; >> >> $dg->addColumn(new Structures_DataGrid_Column('Name', 'name', >> 'name')); $dg->addColumn(new >Structures_DataGrid_Column('URL', 'url', >> 'url')); $dg->addColumn(new >Structures_DataGrid_Column('Date', 'date', >> 'date')); >> >> >> // assign content to template >> $tpl->assign('content', $dg->renderer->toHTML($dg)); >> $tpl->assign('pagination', $dg->renderer->getPaging()); >> >> TIA, mark >> >> -- >> PEAR General Mailing List (http://pear.php.net/) To unsubscribe, >> visit: http://www.php.net/unsub.php >> >> > > >-- >Justin Patrin >