Hey chaps

Im starting up a website, which will list the records that are forthcoming on approx 30 dance record labels. Basic info such as Artist, Title, Catalogue Number, and expected release date of the particular record.

rather than create webpages by day/month etc, id like a user to be able to search by their own date string and then theyll be shown what is due for release on the date they entered.

for example, theyd enter 25-06-2007, and 5 labels might have records to be released on that day.

how would you reccomend i go about this? ive been reading a bit on mysql, it seems to be what i need?

cheers, swisso

any type of sql really.. but mysql is probably more suited to web apps

a front end interface can be developed for the web using html/javascript...

my second year team project was a database system built from scratch using oracle sql and java script, we had to develop every form and every operation as we had no access to the enterprise management console (where you can generate forms using the wizard)

took us a solid 4 weeks working 10am-8pm 5 days a week (4 of us)...

but it depends what kind of things you want it to actually do, if its just a search and display database then not a problem

you might want to add options to request data updates, so if a record is coming out on a particular day the user has the option to request its addition, or if a date is wrong then they can request it to be updated

the database would run server-side, so the HTML wouldnt do anything apart from take the java-script (retrieving the information from the database with SQL commands) and execute it