Results 1 to 4 of 4
Jun 7, 2001, 20:13 #1
Script to keep track of storage slots.
I am trying to design a script to keep track of the slots on a trailer for boats. The trailer has 12 slots like this:
I want to keep track, and allow people to sign up for specific slots, and then I want to be able to clean it out, and start over, with a blank graph every week. What I don't understand is how I should setup my MySQL table. I don't even really know were to start, and also, how should I do the forms, have a button in all the empty one, saying CLICK HERE, that will take them to a separate form, where they can sign-up? or something different? And also, I want to show the names of each person, in the slot they have chosen. I have some other stuff that I want to do, but I think that I can do that, once I get this project off the ground. Thanks a ton!
Jun 7, 2001, 20:15 #2
Jun 7, 2001, 20:43 #3
- Join Date
- Feb 2001
- New Zealand
- 0 Post(s)
- 0 Thread(s)
For something really simple,
Give each space in the trailor, a trailor ID, ie tid,
Then when someone inserts their name, it goes in the row where tid = 'whatever'.
| 1 |john |I rule |
And just put a link in the empty ones to a page where they can go and put their name in a space in the trailor. (A link in the actual page, not in the database)
Jun 8, 2001, 07:59 #4
I think I was trying to way over complicate this! So then would I just put an if statement, checking each slot to see if a row was returned? Or how can I do it using 1 query to the database? I don't want to have to query the db 12 times, and then do an if/else for each of the queries, but I guess I will if that is the only thing possible. Or maybe I could add another simple value, that was either 1 or 0 depending if the slot was occupied?