School Closing Database/Help!

[mfoland]

Hello,

I run a radio website: http://mradio105fm.freehostia.com and I have had several requests to do a school closing database. I made a site for the closing database: http://schoolwatch.freehostia.com

I am using MYSQL for the database. I want my users to be able to register with an Institution Name, Type, City, State, their Contact information. I found a script for registration and logon, but I wanted to use my own form, and that would not work.

Here is the form that I want to use: http://schoolwatch.freehostia.com/closenet/register.htm The characters in the form fields are when I was working with the script. I went ahead and changed the form to htm so you can view the form with ease and no problems.

When the schools sign up, they can post using a form like this: http://schoolwatch.freehostia.com/cl...mitclosing.htm

I am unable to make it submit through the database. I am not sure how to go about that.

After the school submits the closing the public can view any closings on this page: http://schoolwatch.freehostia.com/closings . I want the data to be in that format, with even how many closings are in the database. I do want it to show when they submitted as well. I also want the closings to expire at a certain time. I am not sure what to do... I have tried researching everything I can about this.

I am really needing help with this. I have the design part done it seems like, just the scripting and actually making the database to work is all that needs done... lol... Please feel free to PM me or email me.

Thank you so much!

Mike

P.S. Could you possibly develop a script such as this? I really need help and I can't find anything on this!

[sfowler]

This would actually be fairly simple. When I clicked the link you had for the form it went crazy. I would suggest starting over with your own code so that you can fully understand what is going on.

Next go here. Run through all the basic ones. Under advanced take a look at what can be done with dates and sessions. Then look through the PHP Database materials.

That will teach you what you need to know.

Next, do your own database structure (get ahold of phpMyAdmin if you don't already). You will probably want an auto increment column, the School Name, address info, login, password, a field to record open or closed, and a timestamp field with the "On Update, Current Timestamp" selected.

Then when they log in and mark the school as closed it will record when they did so. On your display page you will select the results from the database, then right before each row is displayed, check to see if it is closed. If so, check the timestamp. If it is more than 24 hours hold, update the record to open and display the row again.

This will necessitate them to log in and mark it closed for each day, but they can do that as they make the calls to all the local radio and news stations as well.

[mfoland]

Will I be able to make the closing auto expire? That seems like it would be easier.