Need Help!

[chaminda7245]

I have to complete e-channeling project for my study purpose.I have created following tables tables.

01)Users (user_id,username,password,salution,first_name,last_name,address, tel ,email)

02) Doctors(doc_id,salutation,initials,first_name,surname,address,tel,email)

03)Specialization(spe_id,specialization)

04)Hospital(hos_id,hos_name)

05)Weekdays(week_id,days)

06)Admin Users(admin_id,admin_name,admin_password)

Problem is I need to allow user to select doctors by using multiple list box and when he login show only he's selected doctors.

without loging users can search doctors by name by specilazation by hospital by weekdays(Monday to Sunday)(If monday selected need show whole monadys in month )

Other is how can I show doctors available date and time for the users.

Please let me know how can i create relationship between tables

Thanks

[nrg_alpha]

I would suggest looking at online mySQL (or whatever other database management system you plan on using) tutorials and going from there. There should be plenty of info out there on table relationships, joins, etc..

I have you already did some coding for this, I recommend showing it upfront so that others can see what you have done so that they can better guide you.

Cheers,

NRG

[chaminda7245]

Thanks for the reply.Not yet done the coding.