It is very possible, and not even that difficult.
Since you are new to PHP and MySQL I suggest you first work out a few examples from the manual to get used to how PHP and MySQL work together,
storing a fetching data to and from the database.
As for your idea, you'd probably need only two tables,
one for the members and their profiles, and one for the resources.
Members:
MemberID mediumint primary key auto_increment not null
Firstname varchar(128)
lastname
email
and other info you might want to store
and for the resources:
ResourceID mediumint primary key auto_increment not null
MemberID mediumint not null <--- this refers to the MemberID from the members table so we can back-track who entered this resource.
URL varchar(250)
Rating mediumint
maybe some info about date of creation and such.
You can find out how many resources a person added by doing a query like this on the resources table:
SELECT count(*) FROM resources_table WHERE MemberID=2;
Or, if you want to get the whole top10 at once:
SELECT MemberID,count(*) FROM resources GROUP BY MemberID;
play around with the queries using the commandline mysql interface.
