note 54207 added to function.mysql-data-seek
| From: | jonybd at yahoo dot com | Date: | Mon, 27 Jun 2005 12:40:48 +0000 |
| Subject: | note 54207 added to function.mysql-data-seek | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-91014@lists.php.net to get a copy of this message | ||
/*
helpfull for real time databases query
- Query one time
- Retreive data twice from the same query
- mysql_data_seek *
*/
include("p_MySql_Connection.php");
$v_Query = "SELECT f1 from t1";
$v_Result = mysql_query($v_Query, $v_RS);
/*
First loop for one single query
*/
while ($row = mysql_fetch_array($v_Result,MYSQL_NUM)) {
$v_total = $v_total + $row[1];
}
echo $v_total;
/*
Retreive data
*/
$v_Re = mysql_data_seek($v_Result,0);
if (!$v_Re){
echo 'MySql data seek Error' . mysql_error();
}
/*
Second loop for one single query
*/
while ($row = mysql_fetch_array($v_Result,MYSQL_NUM)) {
echo $row[0];
}
----
Manual Page -- http://www.php.net/manual/en/function.mysql-data-seek.php
Edit -- http://master.php.net/manage/user-notes.php?action=edit+54207
Delete: added to the manual -- http://master.php.net/manage/user-notes.php?action=delete+54207&report=yes&reason=added+to+the+manual
Delete: bad code -- http://master.php.net/manage/user-notes.php?action=delete+54207&report=yes&reason=bad+code
Delete: spam -- http://master.php.net/manage/user-notes.php?action=delete+54207&report=yes&reason=spam
Delete: useless -- http://master.php.net/manage/user-notes.php?action=delete+54207&report=yes&reason=useless
Delete: non-english -- http://master.php.net/manage/user-notes.php?action=delete+54207&report=yes&reason=non-english
Delete: other reasons -- http://master.php.net/manage/user-notes.php?action=delete+54207&report=yes
Reject -- http://master.php.net/manage/user-notes.php?action=reject+54207&report=yes
Search -- http://master.php.net/manage/user-notes.php