Is there a better way to do this?
On my page www.thornworx.com/weirdbeard/toptunes.php the contents are generated by a simple MySQL table.
I am trying to design a DBMS so that I can easily update it by a web based script (rather than having to go through PHPMyAdmin on my host provider). I will also add other components as and when they arrive on my site.
It is pretty obvious how it works - there is a select statement that queries by a position field. Values 1-5 appear in the table, then any tune that has position value 6 appear in the "recent top tunes list" (limited to 5).
I was just wondering is there is any better way to do this (for example serving it with a text file), and advice on the DBMS and the best way of doing it...
Thanks a lot