Question: I'm stuck for a while, I try to display the result of a variable that executes a sql query in an html table, here is my code;

```
$REQUT = Doctrine_Query::create()
->select('DISTINCT r.prod , r.di, COUNT(*) as Result')
->from('tabl r')
->groupBy('r.di')
->orderBy('Result ASC') ;

$REQUT->fetchArray();

```

PS : I work in symfony, I am looking to have a view like mysql

Answer: 
You need to loop through the result set. I don't know this particular API, but assuming it works similarly to others:

```
$REQUT = // all that query stuff
while($ROW = $REQUT->fetchArray()) {
    // do something
    var_dump($ROW);
}

```
You can try this to display as a html table... 

```
 $REQUT = Doctrine_Query::create()
->select('DISTINCT r.prod , r.di, COUNT(*) as Result')
->from('tabl r')
->groupBy('r.di')
->orderBy('Result ASC') ;

echo "<table>";
while($ROW = $REQUT->fetchArray()) 
{

echo "<tr><td>".$ROW["prod"]."<td>";
echo "<td>".$ROW["di"]."<td></tr>";
}
echo "</table>";

```