i have 2 db tables, something like:

table1
index,
field1,
field2

table2
index,
pid,
field1,
field2


table2.pid is linked with table1.index

a record in table1 can be linked with 0, 1 or more records in table2


now i want a listing from all the records from table1 with at least 1 record linked in table2, and for each of these records all the records from table2

output something like:

table1.field1 table1.field2

table2.field1 table2.field2

------------------------------

table1.field1 table1.field2

table2.field1 table2.field2
table2.field1 table2.field2


how is the best way to code this in php

you can do a LEFT JOIN in your Sql call which should link them as you want them with table1 being referenced first

 
SELECT * FROM table2 LEFT JOIN table1 ON table1.field1 = table2.field1 WHERE ....

personally id create a VIEW in your MYSQL Server and let the database handle the join