 |
|
 PhpDig.net |
What is PhpDig?
PhpDig is a PHP MySQL based Web Spider & Search Engine. |
mysql_field_seek
Synopsis
bool mysql_field_seek(result_handle, field_offset);
mysql result result_handle:
Result handle returned by mysql_db_query() or mysql_query()
int field_offset: Field
offset to move to
Description
mysql_field_seek() moves the internal pointer in a MySQL query result set to a specific field. Field offsets start at 0.
To be honest, this function is of very limited use. Only the mysql_fetch_field() function is affected by it, using the field offset set by mysql_field_seek() if a field offset is not specified in the call to mysql_fetch_field() .
Example
Example 813. Use mysql_field_seek() in conjunction with mysql_fetch_field()
<pre><?php
// Included code that connects to a MySQL server and sets a default database
// See the MySQL Functions chapter introduction for the source code for the file
include ('mysql_connect.inc.php');
// A SELECT query using a column name and a few functions
$query = "SELECT login, UNIX_TIMESTAMP(), NOW() FROM user";
// Run the query
$mysql_result = @ mysql_query ($query)
or die ("Query '$query' failed with error message: \"" . mysql_error () . '"');
// Grab information on every other field in the result set
// Display the object containing field information
for ($offset = 0; $offset < mysql_num_fields ($mysql_result); $offset += 2) {
mysql_field_seek ($mysql_result, $offset);
print_r (mysql_fetch_field ($mysql_result));
}
?></pre>