PHP.nl

mysql_field_table

mysql_field_table

Get name of the table the specified field is in

Waarschuwing: > mysqli_fetch_field_direct``PDOStatement::getColumnMeta

string **mysql_field_table** resource $result int $field_offset

Returns the name of the table that the specified field is in.

The name of the table on success.

Voorbeeld: A example

<?php

$query = "SELECT account.*, country.* FROM account, country WHERE country.name = 'Portugal' AND account.country_id = country.id";

// get the result from the DB
$result = mysql_query($query);

// Lists the table name and then the field name
for ($i = 0; $i < mysql_num_fields($result); ++$i) {
    $table = mysql_field_table($result, $i);
    $field = mysql_field_name($result, $i);

    echo  "$table: $field\n";
}

?>

Opmerking: > info.deprecated.alias

mysql_fieldtable

mysql_list_tables

Vorige ← mysql_field_seek Volgende mysql_field_type →

Documentatie