Extracting database and building a table

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • James

    Extracting database and building a table

    I don't know where to start and would appreciate some help please...

    I have a mySql database with

    tblDiary
    Date Employee Client
    1/1/04 Smith Bloggs
    2/1/04 Jones United
    2/1/04 Smith Central
    .....etc

    tblEmployee
    Number Name
    1 Smith
    2 Jones
    ....etc

    Thing is I need to get it to display HTML in a date table like this:

    Monday Tuesday Wednesday ...etc
    1/1/04 2/1/04 3/1/04
    Smith Bloggs Central _____
    Jones ______ United _____
    ....etc

    and if the user clicks on say Bloggs it takes them to the booking so
    it can be amended or if they click on _____ it sets up a new entry in
    tblDiary.

    I will be using tblDiary.Data and tblDiary.Employ ee as a compound
    primary key.

    Guidance, samples of php and mySql queries much appreciated.

    Thanks
    James
  • Jan van Mansum

    #2
    Re: Extracting database and building a table

    Maybe this sample will be helpful:


    James wrote:[color=blue]
    > I don't know where to start and would appreciate some help please...
    >
    > I have a mySql database with
    >
    > tblDiary
    > Date Employee Client
    > 1/1/04 Smith Bloggs
    > 2/1/04 Jones United
    > 2/1/04 Smith Central
    > ....etc
    >
    > tblEmployee
    > Number Name
    > 1 Smith
    > 2 Jones
    > ...etc
    >
    > Thing is I need to get it to display HTML in a date table like this:
    >
    > Monday Tuesday Wednesday ...etc
    > 1/1/04 2/1/04 3/1/04
    > Smith Bloggs Central _____
    > Jones ______ United _____
    > ...etc
    >
    > and if the user clicks on say Bloggs it takes them to the booking so
    > it can be amended or if they click on _____ it sets up a new entry in
    > tblDiary.
    >
    > I will be using tblDiary.Data and tblDiary.Employ ee as a compound
    > primary key.
    >
    > Guidance, samples of php and mySql queries much appreciated.
    >
    > Thanks
    > James[/color]

    Comment

    Working...