Hello All,
Maybe you can help me, becouse I was searching for various documentations,
and it seems too difucult for me, becouse everything is so crowded.
I need to built small html file, where I could get listed companies.
I have two tables in my MYSQL database, companies and services.
Company
.. :)
/BoNzO
http://bonzo.sineleven.nu
-Original Message-
From: Andrius Jakutis [mailto:[EMAIL PROTECTED]]
Sent: den 24 augusti 2001 04:05
To: [EMAIL PROTECTED]
Subject: [PHP-DB] can you help to beginner?
Hello All,
Maybe you can help me, becouse I was searching for various
documentations
I won't add to the code suggestions already given, but I will share one
thought about your tables - you absolutely _should_ be using two. Any
given company can have from one service to thousands (take GE,
everything from light bulbs to cruise missiles :). The only way to
capture that data
Actually,
He should be using three. While one company could use many services, you
might also have other companies that offer the same service. So there should
be 3 tables to allow a many-to-many relationship. See my e-mail response to
him.
- Jonathan
Chris Hobbs [EMAIL PROTECTED] wrote in
I realized that as soon as I hit Send - doh! :)
Jonathan Hilgeman wrote:
Actually,
He should be using three. While one company could use many services, you
might also have other companies that offer the same service. So there should
be 3 tables to allow a many-to-many relationship. See my
