note 85412 modified in function.mysql-data-seek by felipe
| From: | felipe@php.net | Date: | Sun, 07 Sep 2008 14:49:37 +0000 |
| Subject: | note 85412 modified in function.mysql-data-seek by felipe | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-144224@lists.php.net to get a copy of this message | ||
Here is a simple function to "peek" at the position of the internal pointer in a query
result:
<?php
function mysql_pointer_position($result_set) {
$num_rows = mysql_num_rows($result_set);
$i = 0;
while($result = mysql_fetch_array($result_set)) {
$i++;
}
$pointer_position = $num_rows - $i;
//Return pointer to original position
if($pointer_position <= $num_rows - 1) {
mysql_data_seek($result_set, $pointer_position);
}
return $pointer_position;
}
?>
--was--
Here is a simple function to "peek" at the position of the internal pointer in a query
result:
function mysql_pointer_position($result_set) {
$num_rows = mysql_num_rows($result_set);
$i = 0;
while($result = mysql_fetch_array($result_set)) {
$i++;
}
$pointer_position = $num_rows - $i;
//Return pointer to original position
if($pointer_position <= $num_rows - 1) {
mysql_data_seek($result_set, $pointer_position);
}
return $pointer_position;
}
http://php.net/manual/en/function.mysql-data-seek.php