Website development PHP/MYSQL ENG

[Proxy408]

Hi there! 

 

Im learning to develop a website that we are planning to use at my work.

But i've encountered an issue i'm not sure how to work around.

See image to understand better.

 

So a driver will be in first row of a color, and next week moves one step to the right.

When they reach the last in their color they start over again.

I think i can make the script to generate a week with everyone getting their place, but i'm not sure on how to store/save it. then open it again.

If i make week 48 and one driver isn't at work one day, i need to be able to change him out without changing my "default" in the DB.

 

So my question is, how should i store this information?

Make a DB with a new table for each week?

Store it in a file? XML, CVS or something like that.

 

Im open to any suggestion.

Today we have this exact setup, but in an excel file, wich is not stable enough.

But excel sort the "jumping around" part nicely.

 

Thanks for any ideas :)

[Proxy408]

Hi James, thanks for quick reply. 

 

My programming skills is not good enough to do the first suggestion. 

I think i get what you mean, but not how to actually write it.

 

So i'll go for the alternative. 

Was thinking something like this but it felt a bit like a waste of storage to do so. 

But at the same time, it can be lot of editing in the permutation from time to time.

 

Thanks for the input!!

[Proxy408]

Thank you so much for the advice.

I'm trying to make the website work for years after i'm not managing it.

Its different trying to think of every scenario that has to work without someone knowing the DB/structure etc.

 

Been re-doing a few pages/tables so far ^^

[Proxy408]

What is the difference between SQLite and MySQL?

Using MySQL right now because that was included in my apache app.

 

This part is just a about 10% of my websites functions, just fyi.

Not in a hurry either, so any suggestions that helps out appreciated!