Relationships in MySQL

[philosophology]

Hi everyone,
I have searched the web countless hours for how to make relationships in MySQL but I still haven't gotten any good responses. I even got more confused!

I have only 2 tables. A and B. The relationship between them is one-to-many.
That means any a belonging to A has one or many b's belonging to B.

A -------1:N---------< B

How do I do this with php and MySQL? can someone please explain it to me like I'm a 2 year old?

Thank you.

[NogDog]

The relationships are normally realized by the use of JOINs in your queries, e.g.:

SELECT a.c1, a.c2, b.c1, b.c2 FROM a [color=red]INNER JOIN b ON a.id = b.id[/color]

[philosophology]

NogDog wrote:

The relationships are normally realized by the use of JOINs in your queries, e.g.:

SELECT a.c1, a.c2, b.c1, b.c2 FROM a [color=red]INNER JOIN b ON a.id = b.id[/color]

What are c1, c2, and id?

Explain like I'm a 4 year old please 🙂

thank you.

[NogDog]

philosophology wrote:

What are c1, c2, and id?

Explain like I'm a 4 year old please 🙂

thank you.

Those are just hypothetical column names, while "a" and "b" are hypothetical table names. In this example, "id" is the column name in both tables for the field which establishes the relationship between the tables, possibly an auto-incremented, integer, primary key field in table "a", which is then used in table "b" to link each record to the corresponding record in table "a". So in this example, the two tables would consist of (at least):

Table a
------------
id   INT AUTO_INCREMENT PRIMARY KEY
c1
c2

Table b
------------
id  INT
c1   (not necessarily the same as the same column in table a)
c2   (ditto)