In php, we need to return the initial position of the dataset mysql_data_seek function. the code below is as follows:
The code is as follows:
// Start snipit 1
$ SQL = "SELECT * from
Tips and comments
Note:
The code is as follows:
$ Con= mysql_connect ("localhost", "hello", "321 ");
If (! $ Con)
{
Die ('could not connect: '. mysql_error ());
}
$ Db_selected = mysql_select_db ("test_db", $ con );
$ SQL = "SELECT * from Person ";
$ Result = mysql_query ($ SQL, $ con );
Print_r (mysql_fetch_row ($ result ));
Mysql_data_seek ($ result, 3 );
Print_r (mysql_fetch_row ($ result ));
Mysql_close ($ con );
?>
The code is as follows:
Array
(
[0] => Adams
[1] => John
[2] => London
)
Array
(
[0] => Carter
[1] => Thomas
[2] => Beijing
)
";$ Result = mysql_query ($ SQL );While ($ row = mysql_fetch_assoc ($ result )){// Do stuff with $ row}Mysql_data_seek ($ result, 0); // The key is hereWhile ($ row = mysql_fetch_assoc ($ result )){// Do other stuff with $ row}?> Definition and usageThe mysql_data_seek () function moves the internal result pointer.SyntaxMysql_data_seek (data, row) parameter descriptionData is required. Returns a result set of the resource type. This result set is obtained from the call of mysql_query.Row is required. The number of rows of the new result set pointer to be set. 0 indicates the first record.DescriptionMysql_data_seek () moves the row pointer inside the MySQL result specified by the data parameter to the specified row number.Call mysql_fetch_row () to return the row.Row starts from 0. The value range of row is from 0 to mysql_num_rows-1.However, if the result set is empty (mysql_num_rows () = 0), moving the pointer to 0 fails and an E_WARNING error is returned. mysql_data_seek () returns false.Return valueIf the call succeeds, true is returned. if the call fails, false is returned.Mysql_data_seek () can only be used with mysql_query (), but cannot be used with mysql_unbuffered_query ().Example Output: