update a field by 1?

[homer09001]

i got a system where pilots submit reports what i want to do is make a most active script for my site where it would SELECT * from $table WHERE reports = the highest number

but.......

how do i update the reports field in $table to increase by 1 everytime that user submits a report

and 2

how do i get anouther page to queery the database to get the info of the user with the most reports?

im kinda new to php so help with th ecoding and explanation would be greatly appreciated

[homer09001]

also i wanna limit my mber list so it shows only 10 members per page and i want to add them, page numbers to the bottom so if they clicked the 2 it would take them to teh page with the next 10 any ideaS?

[Weedpacket]

1) update $table set the_field=the_field+1
2) Search for the word "pagination"