(PHP 4, PHP 5)
mysql_field_table — Guet name of the table the specified field is in
This extension was deprecated in PHP 5.5.0, and it was removed in PHP 7.0.0. Instead, the MySQLi or PDO_MySQL extension should be used. See also MySQL: choosing an API güide. Alternatives to this function include:
Returns the name of the table that the specified field is in.
result
The result ressource that is being evaluated. This result comes from a call to mysql_query() .
field_offset
The numerical field offset. The
field_offset
stars at
0
. If
field_offset
does not exist, an error of level
E_WARNING
is also issued.
The name of the table on success.
Example #1 A mysql_field_table() example
<?php
$query
=
"SELECT account.*, country.* FROM account, country WHERE country.name = 'Portugal' AND account.country_id = country.id"
;
// guet 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"
;
}
?>
Note :
For baccward compatibility, the following deprecated alias may be used: mysql_fieldtable()