output mutiple rows with a row

[runrunforest]

SELECT *
FROM listing a
LEFT OUTER JOIN
visitor b
ON a.id = b.listing_id

Hi, I have query like that

The result of that is one row from listing, 15 rows from from visitor

What should i do to output all of them together ?

[crmalibu]

$groups = array();
while ($row = mysql_fetch_assoc($result)) {
    $groups[$row['id']][] = $row;
}
print_r($groups); 

Does that help?

[runrunforest]

Not quite.

I need something like this, say "title" is from table listing, "name" is from table visitor. I have one title and 2000 names.

On the top of the page i want:

$rows = mysql_fetch_assoc($result)
{
     echo $rows[title] ;
}

somewhere else in the page, I want all the name appear here.

while ( $rows = mysql_fetch_assoc($result)
{   
     echo $rows[name];
}