> hi,

> 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