Coding problem!!!!!

[FidoDifo]

With this code, it will list out 1,2,3,4,5 and so on......

<?

$displayperpage = 10;
for($i=1;$i<=$displayperpage;$i++)
{
echo "<br>".((($nowpage-1)*$displayperpage)+$i);
}

?>

If I need to query results from the database with this kind of code,
How do i do it???
Need it to do for paging....

Thanx!!!

[benbox]

do you mean just listing things in a database table?
if so and it is mysql you can use while...

$sql = mysql_query("SELECT FROM tablename") ;
while ($row = mysql_fetch_array($sql)) {

$name = $row["name"] ;
$age = $row["age"] ;

print "$name ($age)" ;
}

kinda thing..

that wud do the print for every item in the table (like your loop)

this what u ment?

[benbox]

I see what you mean now...

you could use LIMIT

mysql_query("SELECT FROM table LIMIT 10, 5") ;

for an example..

look it up... i think that wud mean the 5 results after the 10th... but it might be visa versa..

[FidoDifo]

Hey thanx...!!!
Actually I am doing this paging with the next/prev button...!!!
I kind of have problems with the logic of it...
Anyway, i will give it a shot first!! 🙂

Thanx anyway!!!