That's an extremely broad question. Essentially what you're asking is "how do I script using php/mysql", and that would take a long long time to explain. I've been learning php/mysql for about 4 months now, and I'm far from mastering it.
So, I suggest visiting php.net, phpbuilder.com or sitepoint.com, or even studying the Geeklog code to get an idea on what it's all about. Better yet, get a good book on php.
A basic answer to your question... connect to the database, query the database, put the data into an array, then display the data. -----Matty
Matty