Re: [PHP] Paging Help

2006-06-20 Thread Adam Zey
Andrei wrote: Since you query all enregs from table why not query all first and the do mysql_data_seek on result? // Query to show $query_rsData = "SELECT * FROM {table} ORDER BY {Whatever field}"; $rsData = mysql_query($query_rsData, $DB_CONECTION); $num_total_records = mysql_num_rows(

Re: [PHP] Paging Help

2006-06-20 Thread Andrei
Juanjo Pascual wrote: > // Num of records each time > $NUM_RECORDS = 10; > > if ($_GET["pag"] == "") { >$ini = 0; >$pag = 1; > } > else { >$ini = ($pag - 1) * $NUM_RECORDS; > } > > // Query to show > $query_rsData = "SELECT * FROM table LIMIT " . $ini . ", " . $NUM_RECORDS; > $rsData

Re: [PHP] Paging Help

2006-06-20 Thread Juanjo Pascual
Links for the pages --- First page: this_page.php?pag=1 Previous page: this_page?pag= Next page: this_page?pag= Last page: this_page?pag= Rodrigo de Oliveira Costa escribió: I have the following problem, I need to make a paging system to show results from search on a Mys

[PHP] Paging Help

2006-06-20 Thread Rodrigo de Oliveira Costa
I have the following problem, I need to make a paging system to show results from search on a Mysql database. I found a class that should do the job but couldn't figure it out how to use it. Does anybody has an Idea of hos to do this? I thank in advance for any help you guys can provide me. R