i'm trying to do queries across multiple tables using DQL and need the
results in a mysql_fetch_assoc style.
Doctrine either hydrates the output into nested objects based on the
relations or throws a zero based index array. I tried with all
HYDRATE_ARRAY, HYDRATE_RECORD, HYDRATE_NONE.

is there some way to use such an option with dql?

example: (this was the only way i managed to get my fetch_assoc
vector)

                $results_query=Doctrine_Query::create()
                                                ->setHydrationMode(Doctrine::HYDRATE_ARRAY)
                                                ->select('p.id, p.player_name, b.band_name, u.user_name')
                                                ->from('PlayerResource p')
                                                ->leftJoin('p.Band b')
                                                ->leftJoin('p.User u')
                                                ->execute();

                $results=array();
                $i=0;
                foreach($results_query as $result_query)
                {
                        $results[$i]=array();
                        $results[$i]['id']=$result_query['id'];
                        $results[$i]['player_name']=$result_query['player_name'];
                        $results[$i]['band_name']=$result_query['Band']['band_name'];
                        $results[$i]['user_name']=$result_query['User']['user_name'];
                        $i++;
                }

thanks
Ionut