Re: [PHP-DB] Paginatating PHP

2006-12-21 Thread chris smith
On 12/21/06, Ondrej Kohout <[EMAIL PROTECTED]> wrote: It's better to use SQL_CALC_FOUND_ROWS and information function FOUND_ROWS(). Has nothing to do with the problem. "its simply showing the else condition which does not have NEXT or PREVIOUS hyperlinked." Try "OKi98's" suggestion, it will m

Re: [PHP-DB] Paginatating PHP

2006-12-21 Thread Ondrej Kohout
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 bu

Re: [PHP-DB] Paginatating PHP

2006-12-21 Thread OKi98
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_