php - Zend Framework Error Notice -

php - Zend Framework Error Notice -

i'm trying run code.. error saying..

notice: undefined offset: 0 in c:\wamp\www\address\application\views\scripts\index\index.phtml on line 64 phone call stack # time memory function location 1 0.0006 374544 {main}( ) ..\index.php:0 2 0.0866 4624240 zend_application->run( ) ..\index.php:26 3 0.0866 4624240 zend_application_bootstrap_bootstrap->run( ) ..\application.php:366 4 0.0867 4624416 zend_controller_front->dispatch( ) ..\bootstrap.php:97 5 0.0984 5320368 zend_controller_dispatcher_standard->dispatch( ) ..\front.php:954 6 0.1136 5637296 zend_controller_action->dispatch( ) ..\standard.php:295 7 0.1154 5674032 zend_controller_action_helperbroker->notifypostdispatch( ) ..\action.php:527 8 0.1154 5674792 zend_controller_action_helper_viewrenderer->postdispatch( ) ..\helperbroker.php:277 9 0.1155 5674792 zend_controller_action_helper_viewrenderer->render( ) ..\viewrenderer.php:960 10 0.1166 5675008 zend_controller_action_helper_viewrenderer->renderscript( ) ..\viewrenderer.php:921 11 0.1166 5675008 zend_view_abstract->render( ) ..\viewrenderer.php:900 12 0.1168 5716176 zend_view->_run( ) ..\abstract.php:888 13 0.1171 5724528 include( 'c:\wamp\www\address\application\views\scripts\index\index.phtml' ) ..\view.php:108

this code...

<?php if (isset($_post['search'])) { $db = new zend_db_adapter_pdo_mysql(array( 'host' => 'localhost', 'username' => 'root', 'password' => '', 'dbname' => 'addressdb' )); $db->setfetchmode(zend_db::fetch_obj); $result = $db->fetchall('select * user u_name = ?', $_post['search']); echo $result[0]->add1; echo'<br><br><table width="200px" >'; echo'<tr ><th class="search">name</th><td class="search">:</td><td class="search">'. $_post['name'].'</td></tr>'; echo'<tr ><th class="search">address1</th><td class="search">:</td><td class="search">'.$result[0]->add1.'</td></tr>'; echo'<tr ><th class="search">address2</th><td class="search">:</td><td class="search">how</td></tr>'; echo'<tr ><th class="search">address3</th><td class="search">:</td><td class="search">are</td></tr>'; echo'<tr ><th class="search">telephone</th><td class="search">:</td><td class="search">you..</td></tr></table>'; } ?>

can please tell me wrong???

try doing:

$result = $db->fetchall('select * user u_name = ?', $_post['search']); $countresult = count($result); if($countresult > 0 ) { echo $result->add1; } else { ..you dont have records, show proper message }

if fetching single row, do:

$result = $db->fetchrow('select * user u_name = ?', $_post['search']); $countresult = count($result); if($countresult > 0 ) { echo $result->add1; } else { ..you dont have records, show proper message }

php mysql zend-framework