The answer to your question is the relational model of databases. So instead of one big table, you have to use 2. Say first table is employee and the second - companies. in the employee we have some fields and one of them is company_id, this id corresponds to a single row in the companies table. companies table contains several fields nut one of them is company_id. company_id is a foreign key (the link you ask).
How to get all employees from single company: select employee.* from employee,companies where employee.company_id=companies.company_id and companies.company_name='Some Ltd. Inc.'; or better select employee.* from employee left join companies using(company_id) where company_name='Some Ltd Inc.'; I do not have links to literature about relational model but I remember that on www.phpbuilder.com there is/are some info on it.I think from y.2000. Regards, Andrey Hristov Andrey Hristov Web Developer ----- Original Message ----- From: "sg" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, January 06, 2002 7:26 PM Subject: [PHP-DB] PHP/MySql - address book > Hi, > > I'm trying to do a sort of address book where I'd put all information about > anybody or any company from which I receive informtation (friend, people > from work, hotels, places...) > > An entry starts with a name, then I can have any type of information. The > table I'm using has a lot of fields, but I display via PHP only those that > are not empty. > > I'm now facing a problem many must have already faced. A lot of people work > for the same company, and I'd like to have a separate table or storage area > to put that data, so that I don't have to write the same company addresse > twice, and if that information changes, I won't have to go through ten or > twenty people's entries to modify it. > > So how would I link a company's information to a person's entry? > > I know it may sound easy or ridiculous a question, but though I know HTML > very well I'm still a beginner (learning on my own) et PHP and MySql. > > So far I have a neat rendering of the database I've created, but I feel I > should look further into DB use. > > Software I'm using: > > EasyPHP (latest version) > PHP 4 > MySql > PhpMyAdmin > > on Windows Me > > Main question, I repeat is : how would I link a company's information to a > person's entry? > > Cheers > > Sébastien > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
