As part of my job, I provide IT training to a number of customers. I have been asked by a few customers to provide on my website, a database of courses attended by their staff.

 

I'm going to need to..

 

1. Store student name, date attended, course name and date next course is due

2. Attach a certificate (probably in PDF format) so that they can print it off

3. Provide a user name and password for each customer

4. Ensure that cutomers can only see their own records

5. Provide a rudimentary query feature (eg: by date range)

 

My web server supports PHP4, MySQL and Chillisoft ASP and I have been using DreamWeaver as the development platform.

 

Does anyone have any recommendations as to the easiest route I should take for this project? Any links to good resources on the web would also be useful. I've been a database programmer for many years (bit rusty) but have never produced anything web based before.. :(

 

Really appreciate any pointers people as I'm running short on time!

 

Many thanks for any help or advice :bow:

 

Steve :smw:

 

 

* EDIT* Or should I just pay someone to do it? If anyone has the time and expertise available then PM me!

try and find this book

 

http://www.amazon.co.uk/exec/obidos/ASIN/067232525X/qid=1097833978/ref=sr_8_xs_ap_i1_xgl/202-6579074-5988612

 

 

http://www.hotscriptz.com may have some source code you can look at to get some ideas.

 

I have a similar project in the works, but i don't start coding until next month sometime.

try and find this book

 

http://www.amazon.co.uk/exec/obidos/ASIN/067232525X/qid=1097833978/ref=sr_8_xs_ap_i1_xgl/202-6579074-5988612

 

 

http://www.hotscriptz.com may have some source code you can look at to get some ideas.

 

I have a similar project in the works, but i don't start coding until next month sometime.

 

Top man Mike - that book's got some good reviews as well! Hotscriptz looks superb as well! Just the sort of thing I was after..

 

Steve :)