how do i count rows if my database is PostgreSql? i'm trying to do pagination... :queasy:
i've got this tutorial using MySQL
$limit = 25;
$query_count = "SELECT count(*) FROM table";
$result_count = mysql_query($query_count);
$totalrows = mysql_num_rows($result_count);and i tried to convert it so that it can be used for PostgreSql....
$limit = 25;
$sql_count = "select count(*)from table";
$sql_data = dbSelect($sql_count); //this function was written by someone else long long time ago
$totalrows = ?????????????????
what should i put to replace mysql_num_rows? thanks!!