[SOLVED] Combine data from two tables in a [while] loop

[patrickm]

I'm having problems cracking a SQL/PHP nut.

 

Situation: table 1 contains several information about products (among the field, there are $code and $product_description).

T ???able 2 contains specific information with which can be determined which product you need (it also contains the field $code).

 

From table (no.2) I select the right products when a certain variable = "something".

The outcome is processed using

while ($dump_resultaat = mysql_fetch_object($resultaat)) {

...

}

 

But here it comes ... in this loop, the valid info from field $code in $dump_resultaat should be used to retrieve information from table 1 in which there is also a field called $code.

$code is used as a reference in both tables.

 

How do I build this?

I've tried to combine things in PHP, but unfortunately to no avail.

 

Any pointers would be appriciated!

[jworisek]

can't get it all in one SQL statement?

 

SELECT * FROM table1 LEFT JOIN table2 ON (table1.code=table2.code) where .....

[bubblegum.anarchy]

Use an inner join to return only all record in table 2 that have a matching table 1 id.

[patrickm]

Thanks for the suggestions.

 

I've done some searching and found a useful page on Wikipedia.

 

Super!