http://propel.phpdb.org/trac/wiki/Users/Do...2/Relationships . Robiłem wszystko wg instrukcji i nie wychodzi mi ;/
<?php //Komentarze $cc = new Criteria(); $cc->add(CommentPeer::QUESTION_ID, $this->getRequestParameter('id')); $cc->addAscendingOrderByColumn(CommentPeer::CREATED_AT); $this->comments = CommentPeer::doSelectJoinUsers($cc); ?>
<table name="comment" phpName="Comment"> <column name="id" type="integer" required="true" primaryKey="true" autoIncrement="true" /> <column name="question_id" type="integer" required="true" /> <column name="author_id" type="integer" required="true" /> <foreign-key foreignTable="users"> <reference local="author_id" foreign="id"/> </foreign-key> <column name="created_at" type="timestamp" /> <column name="updated_at" type="timestamp" /> <column name="title" type="varchar" size="255" required="true" /> <column name="body" type="longvarchar" required="true" /> </table>
zwraca mi autor:Object id #121. Jak sie dostac do poszczegolnych pol np. nickname czy id?
<?php if($comments) : ?> <?php foreach ($comments as $comment): ?> <div class="comment" style="margin-bottom:10px;"> </div> <?php endforeach ?> <?php endif ?>