in reply to Need help with pagination

Where exactly do you need help?

What is not working, and how is it failing?

Also, you should not interpolate user-supplied data into strings and then pass them to your SQL database. Use DBI placeholders instead.

Also, this code looks suspicious:

while( ($ARTICLE{'name'},$ARTICLE{'author'},$ARTICLE{'label'},$ART +ICLE{'price'},$ARTICLE{'pochette'},$ARTICLE{'genre'})=$c->fetchrow()) + { $total +=1; }

Maybe you wanted to do a select count(*) from ... instead, to make the database do the work?

Replies are listed 'Best First'.
A reply falls below the community's threshold of quality. You may see it by logging in.