note 106668 modified in function.mysql-data-seek by danbrown
| From: | danbrown@php.net | Date: | Tue, 29 Nov 2011 15:44:34 +0000 |
| Subject: | note 106668 modified in function.mysql-data-seek by danbrown | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-184792@lists.php.net to get a copy of this message | ||
Here, you can find the current pointer of selected row easily:
<?php
//selected row with id=4
$id = "4";
$result = mysql_query("select * from jos_components");
$num = mysql_num_rows($result);
for($i=0;$i<$num;$i++){
mysql_data_seek($result,$i);
$row = mysql_fetch_assoc($result);
if($row['id'] == $id){
$pointer = $i;
}
}
// current pointer for selected row
echo $pointer;
?>
--was--
Here, you can find the current pointer of selected row easily:
//selected row with id=4
$id = "4";
$result = mysql_query("select * from jos_components");
$num = mysql_num_rows($result);
for($i=0;$i<$num;$i++){
mysql_data_seek($result,$i);
$row = mysql_fetch_assoc($result);
if($row['id'] == $id){
$pointer = $i;
}
}
current pointer for selected row
echo $pointer;
http://php.net/manual/en/function.mysql-data-seek.php