Jump to content

help building tables


youngboy84

Recommended Posts

hi all this is my first post so hello.

I am tring to learn php and build a project that i will use. so this is my project.

basically i am building a work rota that has a sign up/sign in page and a members area.

so after you register and sign in you will go to a members area which will display your personal rota for the year.

i am still in the planing stage so go easy on me. What i need help with is how best to make tables for my project.

 

so far i have created a database called rota and a table called users with

1. id int

2. username varchar

3. password varchar

4. shift enum '1','2','3','4' (not sure if enum will work to choose shift????)

 

so for example i am shift 3 so my members area shiuld display a calender with red squares for day shift and blue for night for every month.

 

Mabey this is too hard for a beginner but i will try my best. ANY HELP AND criticisms WELCOME

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.