Invalid query: Duplicate entry '0' for key 3

[Hoangsta]

i have two tables: BusinessName and Customers

BusinessName
Business_id
customer_id

Customers
customer_id

.......
customers can have more than one business (1-to-many)
......

I am inserting data from a form into two tables....I am also using myAdmin to create my tables....i know that myAdmin does not do any FK (foreign key) How sould I structure my table?

if anyone have an idea of what i need...it would help me out. my ftp is not working right now, so i can't load my syntax...it's simply and insert statement with values nothing more...

[bad76]

Hi,
you can make BusinessName.Business_id and Customers.customer_id key, unique autoinc and use these as foreign key. It's enough for link the two tables.

see you

[Hoangsta]

i think i understood u correctly....

Table: BusinessName
Customer_id (FK)
Business_id (PK)

Table: Customer
Customer_id(FK)

???

[bad76]

Not exactly, this:

Table: BusinessName
Customer_id (FK)
Business_id (PK)

Table: Customer
Customer_id(PK)

where

Table: BusinessName
Business_id AS integer primarykey, unique, autoinc
Customer_id AS integer

Table: Customer
Customer_id AS integer primarykey, unique, autoinc

Then is enough to join the Customer_id:

SELECT B.Customer_ID, C.Customer_ID
FROM BusinessName B, Customer C
WHERE B.Customer_ID=C.Customer_ID
AND B.Customer_id=$myid