Extracting database and building a table

[James]

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]

Re: Extracting database and building a table

Maybe this sample will be helpful:

http://www.phppatterns.com/index.php/article/articleview/19/1/1/

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]