Re: [apdance9] Displaying records
Hi April,
You can do this using the meta data that we return using get Records.
For example:
list($articleRecords,$articleMetaData)=getRecords(array(
'tableName' => 'articles',
'perPage' => 10,
));
We can output your information like this:
Showing <?php echo $articleMetaData['pageResultsStart'];?> - <?php echo $articleMetaData['pageResultsEnd'];?> of <?php echo $articleMetaData['totalRecords'];?>
The first two values will change depending on what page you're on. $articleMetaData['totalRecords'] will display the total records returned by the query, not necessarily all the records in the database. If you want to show the number of records in a particular table, you can try this:
<? echo mysql_select_count_from('articles','');?>
Hope this helps
---------------------------------------------------
Jason Sauchuk - Project Manager
interactivetools.com
Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/