name);    printf("Table:    %s\n", $finfo->table);    printf("max. Len: %d\n", $finfo->max_length);    printf("Flags:    %d\n", $finfo->flags);    printf("Type:     %d\n\n", $finfo->type);mysqli_free_result($result);}/* close connection */mysqli_close($link);?>">

Set result pointer to a specified field offset (original) (raw)

`<?php
$link = mysqli_connect("localhost", "my_user", "my_password", "world");/* check connection */
if (mysqli_connect_errno()) {
printf("Connect failed: %s\n", mysqli_connect_error());
exit();
}$query = "SELECT Name, SurfaceArea from Country ORDER BY Code LIMIT 5";

if ( result=mysqliquery(result = mysqli_query(result=mysqliq​uery(link, $query)) {/* Get field information for 2nd column /
mysqli_field_seek($result, 1); finfo=mysqlifetchfield(finfo = mysqli_fetch_field(finfo=mysqlif​etchf​ield(result);printf("Name: %s\n", $finfo->name);
printf("Table: %s\n", $finfo->table);
printf("max. Len: %d\n", $finfo->max_length);
printf("Flags: %d\n", $finfo->flags);
printf("Type: %d\n\n", finfo−>type);mysqlifreeresult(finfo->type);mysqli_free_result(finfo−>type);mysqlif​reer​esult(result);
}/ close connection */
mysqli_close($link);
?> `

Name: SurfaceArea Table: Country max. Len: 10 Flags: 32769 Type: 4