note 72565 added to function.pdo-query

Look out for re-using this same variable for PDOStatement twice. You should always clear it if you want use it again. <?php /* WRONG */ $oPDO = new PDO(); $oPDOStatement = $oPDO->query('SELECT something'); /* making something with $oPDOStatement, i.e. fetch() */ $oPDOStatement = $oPDO->query('SELECT something completly different'); /* and now $oPDOStatement is unuseful, fetch() doesn't returns result etc. */ ?> But... <?php /* GOOD */ $oPDO = new PDO(); $oPDOStatement = $oPDO->query('SELECT something'); /* making something with $oPDOStatement, i.e. fetch() */ /* and destroy poor, little object as we had used it */ $oPDOStatement = null; $oPDOStatement = $oPDO->query('SELECT something completly different'); /* and everything works fine */ ?> ---- Server IP: 69.147.83.197 Probable Submitter: 83.177.186.74 ---- Manual Page -- http://www.php.net/manual/en/function.pdo-query.php Edit -- https://master.php.net/note/edit/72565 Del: integrated -- https://master.php.net/note/delete/72565/integrated Del: useless -- https://master.php.net/note/delete/72565/useless Del: bad code -- https://master.php.net/note/delete/72565/bad+code Del: spam -- https://master.php.net/note/delete/72565/spam Del: non-english -- https://master.php.net/note/delete/72565/non-english Del: in docs -- https://master.php.net/note/delete/72565/in+docs Del: other reasons-- https://master.php.net/note/delete/72565 Reject -- https://master.php.net/note/reject/72565 Search -- https://master.php.net/manage/user-notes.php