Anyone reccommend a good php/mysql script for holding a load of profiles like the ones you see on sports sites for players?

Profile Manager Premium is very flexible, I think it can help you with what you are planning to do:
http://www.interlogy.com/products/pmpre/

It is not php/mysql though.