PHP MySQL Query

[FallingReign]

Hi i was wondering if anyone could help me to get information from 2 different tables in my database...

Associates (table)
-ID
-email

Sales (table)
-ID
-payment

What I need to do is have the above information displayed in a table like the one below. both ID's in the tables sales and associates are identical.

 Email               |  Payments  |  ID  |
email1@mail com     |   $100.00  | ID01 |
[e-mail]     |    $45.00  | ID02 |
 

FallingReign

[Chrisjc]

Hi i was wondering if anyone could help me to get information from 2 different tables in my database...

Associates (table)
-ID
-email

Sales (table)
-ID
-payment

What I need to do is have the above information displayed in a table like the one below. both ID's in the tables sales and associates are identical.

 Email               |  Payments  |  ID  |
email1@mail com     |   $100.00  | ID01 |
[e-mail]     |    $45.00  | ID02 |
 

FallingReign

Why two tables? why not

ID
email
payment

in one table? Just wondering..

[FallingReign]

Why two tables? why not

ID
email
payment

in one table? Just wondering..

There is alot more information than just those values and it would require me to rewrite alot of the website to have the email field in the Sales table.

I was just hopeing that there was some code that i could use instead to retrieve them both.

[simonhuntley]

Hi i was wondering if anyone could help me to get information from 2 different tables in my database...

Associates (table)
-ID
-email

Sales (table)
-ID
-payment

What I need to do is have the above information displayed in a table like the one below. both ID's in the tables sales and associates are identical.

 Email               |  Payments  |  ID  |
email1@mail com     |   $100.00  | ID01 |
[e-mail]     |    $45.00  | ID02 |
 

FallingReign

SELECT * FROM sales_table,associates_table WHERE sales_table.id=associates_table.id