All pastes #746001 Raw Edit

Untitled

public text v1 · immutable
·published 2007-10-22 21:40 UTC
rendered paste body
    $username = $this->getRequestParameter('username');
    $q = new Doctrine_Query();
    $q->select('u.*, COUNT(b.id) count')
      ->from('User u')
      ->leftjoin('u.Blog b')
      ->where('u.username = ?')
      ->groupby('u.id');
    $users = $q->execute(array($username));
    $count =  $users[0]['Blog'][0]['count'];
    echo "test?";
    var_dump($count);
    die('moo?');