16 Jan
2014
16 Jan
'14
7:40 p.m.
I have the following code:
$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.
--
---
drupal.org/user/367108
linkedin.com/in/jeffrgreenberg
accidentalcoder.com / ayendesigns.com
@accidentalcoder