Solved: i made this mistake: <?php echo $mensaje->getUsername() ?> instead of <?php echo $mensaje- >getUser()->getUsername() ?>
Javi On Nov 30, 5:57 am, tirengarfio <tirengar...@gmail.com> wrote: > Thanks Gábor, I finally use a query also. > > This time i would like to show the username of the person who send the > message next to the title and the text of the message. > > I've thought the solution could be execute this query below: > > class MensajeTable extends Doctrine_Table > { > > public static function getMensajesUsuario($id) > { > > $q = Doctrine_Query::create() > ->from('Mensaje m') > ->leftJoin('m.User u') > ->where('m.receptor_id = ?', $id); > > $m = $q->execute(); > > return $m; > > } > > } > > In the controller: > > class mensajeActions extends sfActions > { > public function executeIndex(sfWebRequest $request) > { > $this->mensajes_usuario = MensajeTable::getMensajesUsuario > ($this->getUser()->getGuardUser()->getId()); > > } > > } > > And then showing the results of the query in a template in this way: > > <?php foreach ($mensajes_usuario as $mensaje): ?> > > <?php echo $mensaje->getTitulo() ?> > > <?php echo $mensaje->getContenido() ?> > > <?php echo $mensaje->getCreatedAt() ?> > > <?php echo $mensaje->getUsername() ?> > > <?php endforeach; ?> > > But when i get this error: > > Unknown method Mensaje::getUsername > > Do you know what is going wrong? > > For the Propel people: Do you know if the approach is at least right? > > Bye > > Javi > > On Nov 25, 10:01 am, Gábor Fási <maerl...@gmail.com> wrote: > > > Without any info on how you store the messages, my guess is: > > > $c = new Criteria(); > > $c->add(MessagePeer::USER_ID, $this->getUser()->getId()); > > return MessagePeer::doSelect($c); > > > On Wed, Nov 25, 2009 at 13:45,tirengarfio<tirengar...@gmail.com> wrote: > > > Hi, > > > > as many of you have guessed im making a little social network. > > > > Now i need to fetch the messages of the user receives from other > > > members of the social network. > > > > The line below access to the first message sent to the user: > > > > $this->getUser()->getGuardUser()->getMessage(); > > > > but.....Is there any way to fetch ALL the messages sent to the user?? > > > > I have tried with getMessageS(), or writting that line inside a loop > > > but it doesnt work...:) > > > > Bye > > > > Javi > > > > -- > > > > You received this message because you are subscribed to the Google Groups > > > "symfony users" group. > > > To post to this group, send email to symfony-us...@googlegroups.com. > > > To unsubscribe from this group, send email to > > > symfony-users+unsubscr...@googlegroups.com. > > > For more options, visit this group > > > athttp://groups.google.com/group/symfony-users?hl=en. -- You received this message because you are subscribed to the Google Groups "symfony users" group. To post to this group, send email to symfony-us...@googlegroups.com. To unsubscribe from this group, send email to symfony-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en.