note 54207 added to function.mysql-data-seek

From: 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

« previous php.notes (#91014) next »