mysql output problems

[kalster]

i don't have any code. i am just trying to do the following.

 

$row1      $row2

1                5

2                2

3                3

4                1

5                5

 

$row1 and $row2 are in different mysql tables.

 

in this eample, $row1, number "1" would be printed first followed by anything from $row2 that is the number 1. when i run the program, i would like to first print the $row1 then the $row2 that is associated with $row1. when i print it, it would look like the following...

 

$row1      $row2

1                1

2                2, ect

 

think of row1 as a header and row2 as a footer. i would like to first print the header, then any thing from row2 that has the same number as row1, would be printed next. thank you

 

ps, i can't find anything from google that would help me in this case.