Extracting database and building a table

From: James (just_out_for_fun_at_hotmail.com)
Date: 01/30/04 

Date: 30 Jan 2004 14:34:31 -0800

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.Employee as a compound
primary key.

Guidance, samples of php and mySql queries much appreciated.

Thanks
James

Relevant Pages

  • Re: Extracting database and building a table
    ... James wrote: ... samples of php and mySql queries much appreciated. ...
    (comp.lang.php)
  • Re: "call to undefined function" mysql_error when adding new rows to table
    ... I have recently set up a mysql database of local pubs, ... when I try to add a new pub I get an error message "call to undefined ... Shouldn't be any PHP problem. ...
    (comp.lang.php)
  • Re: breaking into J2EE: steep curve or wrong approach?
    ... > a MySQL database. ... > I'd like to recode the PHP functionality as either servlets or JSPs. ... You need to understand servlets. ...
    (comp.lang.java.programmer)
  • Re: Executing PHP files on remote web server
    ... Is it possible to move a few of the PHP pages -- the ... from the session variables on our web server, but I'm a C and Java ... You should have the same security concern for your own MySQL database. ... users with IP addresses on our network, ...
    (comp.lang.php)
  • Mysql Search
    ... I am not sure if this is a PHP or MySql problem, ... I have a MySql database which has a field containing a list of words (comma ... The user inputs a search word to an HTML form which then ...
    (alt.php)