$query = db_query('SELECT * FROM table1 t1 LEFT JOIN table2 t2 ON t1.id = t2.id');

    $msg = $query->fetchAllAssoc('id');

Since it is 1:many data, I would expect

id 1

  another t1 field

  another t1 field

  t2 value 1

      more t2 from that row

  t2 value 2

      more t2 from that row

id 2

But I only get 1 t2 row for each t1. If I do the same query (without the fetchAllAssoc) in mysql I get the expected results.

accidentalcoder.com / ayendesigns.com

@accidentalcoder