can someone who is more familiar with Doctrine 2 tell me how to code the following query using the Doctrine way of doing things:
Code
sql = "SELECT DISTINCT
$handlersColumn[handler],
$handlersColumn[title]
FROM $handlersTable";
$result = $dbconn->execute($sql);
$handlers = array();
for (; !$result->EOF; $result->MoveNext()) {
$handler = array('handler' => $result->fields[0],
'title' => $result->fields[1],
'mediaTypes' => array());
$handlers[] = $handler;
}
$result->Close();
$handlersColumn[handler],
$handlersColumn[title]
FROM $handlersTable";
$result = $dbconn->execute($sql);
$handlers = array();
for (; !$result->EOF; $result->MoveNext()) {
$handler = array('handler' => $result->fields[0],
'title' => $result->fields[1],
'mediaTypes' => array());
$handlers[] = $handler;
}
$result->Close();
Any hints are much appreciated.
Greetings/Thanks
Robert
