note 114458 added to pdostatement.fetch

From: Date: Sun, 23 Feb 2014 10:30:03 +0000
Subject: note 114458 added to pdostatement.fetch
Groups: php.notes 
Request: Send a blank email to php-notes+get-198595@lists.php.net to get a copy of this message
Because MySQL does not currently support the use of cursors, the $cursor_offset feature cannot work when using PDO to access a MySQL database. If you are tring to arbitrarily access a specific record or group of records in a MySQL database recordset, you might want to consider using the LIMIT clause of the SELECT statement to achieve this e.g. LIMIT 5,3 to return just the 6th,7th & 8th records - 3 records starting at index 5 (which is the 6th record). ---- Server IP: 72.52.91.14 Probable Submitter: 72.52.91.14 ---- Manual Page -- http://php.net/manual/en/pdostatement.fetch.php Edit -- https://master.php.net/note/edit/114458 Del: integrated -- https://master.php.net/note/delete/114458/integrated Del: useless -- https://master.php.net/note/delete/114458/useless Del: bad code -- https://master.php.net/note/delete/114458/bad+code Del: spam -- https://master.php.net/note/delete/114458/spam Del: non-english -- https://master.php.net/note/delete/114458/non-english Del: in docs -- https://master.php.net/note/delete/114458/in+docs Del: other reasons-- https://master.php.net/note/delete/114458 Reject -- https://master.php.net/note/reject/114458 Search -- https://master.php.net/manage/user-notes.php

« previous php.notes (#198595) next »