[edit] Last updated: Fri, 14 Jun 2013

mysql_field_seek

(PHP 4, PHP 5)

mysql_field_seek — Define o ponteiro do resultado para o índice de campo especificado

Descrição

bool mysql_field_seek ( resource $result , int $field_offset )

Move para o índice do campo especificado. Se a próxima chamada a mysql_fetch_field() não incluir um índice, o índice de campo especificado em mysql_field_seek() será retornado.

Parâmetros

result: The result resource that is being evaluated. This result comes from a call to mysql_query().
field_offset: The numerical field offset. The field_offset starts at 0. If field_offset does not exist, an error of level E_WARNING is also issued.

Valor Retornado

Retorna TRUE em caso de sucesso ou FALSE em caso de falha.

Veja Também

mysql_fetch_field() - Obtém informações sobre uma coluna de um resultado e retorna como um objeto

mysql_field_table

mysql_field_name

[edit] Last updated: Fri, 14 Jun 2013

add a note User Contributed Notes mysql_field_seek - [4 notes]

down

chris at igwsolutions dot com ¶

5 years ago


I spent a good deal of time trying to get the example to work, but the example does not work. 

To do what the exaple is trying to do, you would need to use mysql_data_seek



assume we have table named testing which contains

id      name

1       Hassan

2       Jack

3       Rose

---------------



Here is an expample that will do the above example. 



Since I am more comfortable in a OOP setting, I used mysql_fetch_object



<?php

    require("myConnenctionFile.php");

    

    $sql="SELECT  * from testing";

    $result=mysql_query($sql);



    $row = mysql_fetch_object($result);

    echo $row->id . ' ' . $row->name; // Output is (1      Hassan)

    mysql_data_seek($result,2);

    $row = mysql_fetch_object($result);

    echo $row->id . ' ' . $row->name; // Output is (3      Rose)

    echo "<BR><BR>";

?>

down

adrien dot gibrat at gmail dot com ¶

4 years ago


Not dumb at all!!



It means that "mysql_field_seek" and "mysql_data_seek" are moving the same cursor... through the rows and columns of the result resource.



Also means that the cursor goes to a new row when it reach a final field(aka column), by exemple while looping with "mysql_fetch_field".



Calling "mysql_fetch_object", "mysql_fetch_array", "mysql_fetch_assoc"

and "mysql_fetch_row" seems to place the cursor at the end of the line.



So calling "mysql_fetch_field" without a field index, just after that, will return false.

down

Hassan Kazem ¶

5 years ago


an example of this function

assume we have table1 which contains

ID      Name

1       Hassan

2       Jack

3       Rose

---------------

<?php 

mysql_connect("sql.server.com", "username", "password") or die(mysql_error()); 

mysql_select_db("database") or die(mysql_error()); 

$sql="SELECT  * from table1";

$result=mysql_query($sql);

$row = mysql_fetch_array($result);

echo $row['ID'] . ' ' . $row['Name']; // Output is (1      Hassan)

mysql_field_seek($result,2);

echo $row['ID'] . ' ' . $row['Name']; // Output is (3      Rose)

?>

---------------

// You can see that the seek command forwarded the pointer one step and skipped row number 2

down

poulpillusion at free dot fr ¶

6 years ago


A dumb comment... but it may save people some time : 

mysql_field_seek != mysql_data_seek



In order to fetch again the results of a resource result from the beginning, you will use mysql_data_seek(id, 0)

add a note