In message <[EMAIL PROTECTED]>, David Halliday <[EMAIL PROTECTED]> writes >Having one table with 70 >rows is much better than having 70 but one would still >have to enter the patients names in these rows.
No, entering the names here is definitely not the right way to do it. > For >example, say patient "Mr. John Smith" is on 23 >medications and "Mrs Maria Jones" is on 13, then one >would still have to have 7o added columns to the >"patients" table. Alternatively - which sounds so >unreasonable - to add 2000 columns to the "Medicines" >table to take care of patients names. This is where the third table comes in, with just two fields, patient, and drug, to link the tables together. Patient 20 (John Smith) is on drug 23 Patient 31 (Maria Jones) is on drug 13 Patient 31 is on drug 915 Patient 50 is on drug 23 Patient code and patient name in PATIENTS Drug code and drug name in DRUGS Patient code and drug code in LINK -- Pete Clark http://www.hotcosta.com http://www.spanishholidaybookings.com ------------------------ Yahoo! Groups Sponsor --------------------~--> Most low income households are not online. Help bridge the digital divide today! http://us.click.yahoo.com/cd_AJB/QnQLAA/TtwFAA/CefplB/TM --------------------------------------------------------------------~-> The php_mysql group is dedicated to learn more about the PHP/MySQL web database possibilities through group learning. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/php_mysql/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
