Hi everybody,

i create a form,all the form datas store in db.but no data retrive from database.
what is the problem in my code.
nothing to display my template page.

plz help me.

this is my action file:

class planbookActions extends sfActions
{
  public function executeIndex(sfWebRequest $request)
  {

      $planbook_obj= Doctrine_Query::create()->select

('p.personal_id,p.photo,p.title_name,p.zone_id,p.place,p.occasion,p.itinerary,

p.description,p.date')->from('planbook p');
  $result = $planbook_obj->fetchArray();




  }
Indexsuccess.php(templatepage)

<ul>
<?php foreach ($planbooks as $planbook): ?>
<a href="<?php echo url_for('planbook/show?id='.$planbook->getId()) ?>" >
  <li>Name:    <?php echo $planbook->getTitleName() ?></li>
  <li>occasion: <?php echo $planbook->getOccasion() ?></li>
  <li>place: <?php echo $planbook->getPlace() ?></li>
<?php endforeach ?>
</ul>