Need an answer!

[miles_rich]

I know that if i search for paging i will find some answers, but i was wondering if someone could tell me the best way to use paging, at the moment i have it set up so that the like actually has some mysql code in it for example

whatever.php?page_limit=LIMIT 0,10

in the link. i have read about useing ofsets, but im not quite sure how to go about it. could someone help or explain??

please.

[keith73]

instead of passing mysql code, which is insecure, you should do it this way.

whatever.php?start=0&limit=10

then in your query:

$query = "SELECT * FROM tablename LIMIT " . $_GET['start'] . "," . $_GET['limit'];

Passing the mysql code in your query string is BAD because someone else can change it and execute code that will retrieve info out of your database that you don't want them to have, heck, maybe even erase it.

• keith

[miles_rich]

dont spose you have a nice example of paging do you aswell???😃

[xblue]

you seem to have guessed that using the search would get you examples already, so why don't you just do it then?

there are quite some tutorials on this as well - you know how to find them yourself, right😉?

[WindomEarle]

1. decide how many records will be displayed per page.
   $max = 20

2. calculate how many pages are needed for all records.
   2.1 see how many records do you have at all.
   mysql_query() and mysql_num_rows()
   2.2 calculate. $page = your calc code

3. mysql_query("select * from $tbl LIMIT $page, $max);

4. display results and links to other pages
   <a href=$php_self?page=$page+1>Next</a>

something like that.

[keith73]

Originally posted by miles_rich
dont spose you have a nice example of paging do you aswell???😃

do a search on pagination or paging on the forums.

You can even google it at groups.google.com go to alt.php and enter your search there as well.

• keith