How to do this ?

[albaity]

I have a table ..
this table have 20 record..
I want to view this record in the 4 pages (5 record by page)..
how can I do that !!

[cordex]

Use the LIMIT sql function.

$select = "SELECT * FROM table WHERE field='value' LIMIT ". $current .",5";

Where $current is the record number you're on at the time.

[Anon]

no I mean how to do that dynamic , assume that i not know how many records in the table but i want to view five record by page
🙂
how can I do that

[cordex]

That's exactly what I showed you how to do.

all you have to do is keep track of $current (which is, surprise surprise - the current record). In other words, keep sending $current as a hidden variable. So, inaddition to the code I sent before, add something like this:

if($current) $current = $current+5;
else $current="0"

Is it that hard of a concept?