Slideshow from a PHP/MySQl recordset

Hi Folks,
Can anyone help me figure this one out?

I need create a slideshow from a MySQL databse containing image names. All the images are kept in one folder so there should be no address issues. The images will displayed in the same table cell. I have the database ready, the recordset created and I can display one image. My question is, how do I get the next image in the recorset to replace it after a fixed number of seconds. And then the next and so on....?

I have created similar things in the past using Kaosweaver's advanced random images extension but that doesn't seem to allow for images to be loaded from a recordset, which is a shame otherwise it would be perfect for this job.

I am only starting out on my PHP journey but I'm happy to try and piece together a simple bit of code if you can give me an idea what I should be looking at?
Any suggestions what other method or even other extensions I should try?

Cheers


Dave