It's better to use SQL_CALC_FOUND_ROWS and information function FOUND_ROWS().

For more information see http://dev.mysql.com/doc/refman/4.1/en/information-functions.html


Find: FOUND_ROWS()

Iky


OKi98 wrote:

Chris Carter wrote:
>There is enough data to display this result and to paginate but its simply showing the
>else condition which does not have NEXT or PREVIOUS hyperlinked.
>...
>$query_count = "SELECT count(*) FROM students";
>$result_count = mysql_query($query_count);
>$totalrows = mysql_num_rows($result_count);
well, the result is always 1 (even if no students are present), you need to use some mysql_fetch_* function to get the count of students
ie.
$tmp=mysql_fetch_row($result_count);
$totalrows=$tmp[0];


OKi98


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to