Big time php/mysql help!
Ok, I know how to make user forms and processors but I have been assigned a new project at work and I need some help with it and would be forever in anyones debt if they could please help me with this.
This is going to be a bus driver tracking system. Basically all it is going to do is keep track of each bus driver and there info. let me first show you the tables.
Table - drivers /
Last Name /
First Name /
Basicly there personal info in table - drivers.
Table - Driver Sales /
Sale Amount /
This is all sales info
There is one more table but I can figure that out. Ok so I need to do a table join somehow. here is a list of things that ned to be done.
make a form so I can choose the driver and add in sales info.
2. join the tables
3. make a page so when I choose the driver it will pull up the sales info.
thats all it is. im sure its easy but I cant find a book that remotley even tells me how to do it. I have read every book on php and mysql and I am running out of time so if someone can give me a hand I would appreciate it. and if any questions please ask.