• PHP Video Tutorials

PHP - Function MySQLi Data Seek



Syntax

mysql_data_seek(result, row_number )

Definition and Usage

It is used to move internal result pointer.

Return Values

It returns true on success or false on failure

Parameters

Sr.No Parameters & Description
1

result

It specifies result set of identifiers

2

offset

It specifies the field offset.It should be between 0 and the total number of rows - 1

Example

Try out the following example

<?php
   $connection_mysql = mysql_connect("localhost", "user", "pass");  
   $selecteddb = mysql_select_db("tutorials");  
   
   $sql = "select * from tutorials";  
   $result = mysql_query($sql,$connection_mysql);  
   
   mysql_data_seek($result,5);  
   print_r(mysql_fetch_row($result));
   
   mysql_close($connection_mysql);  

?>
php_function_reference.htm
Advertisements