Today i'm using mysql in this way:

$tmp_tbl=mysql_query($sql);
for ($i=0;$i<mysql_num_rows($tmp_tbl);$i++)
 echo mysql_result($tmp_tbl,$i,0);


in pdo sometimes i can't do it because i made an array lke this:

$tmp_tbl=mysql_query($sql);
$array=array(9,3,6,2,6);
for ($i=0;$i<count($array);$i++)
 echo mysql_result($tmp_tbl,$array[$i],0);

so i can't use pdo cause my rows are not sequencialy

if pdo could have a function like

$PDO_STATMENT = $dbh->prepare($SQL);
$PDO_STATMENT->execute();
$array=array(9,3,6,2,6);
for ($i=0;$i<count($array);$i++)
   echo $PDO_STATMENT->result($array[$i],0);  <-----

could help alot

today i'm creating a array putting all data to it and reading the array, but i need many memory and time...

could you undestood?
sorry the poor english

setting current row could help like sqlite2 lib do
sqlite_seek

we will need buffered query!

PDO supported scrollable cursors (and a respective $offset
parameter of PDOStatement::fetch()) even when you filed this
feature request.  However, MySQL doesn't support scrollable
cursors, so there's nothing we can do about that.  Consider to
file a feature request upstream.