Oracle 5.0, Reference Manual

Page: 2294 / 3232

Original MySQL API (
Mysql
)
2274
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.
Return Values
Returns
TRUE
on success or
FALSE
on failure.
See Also
mysql_fetch_field
20.7.2.5.23.
mysql_field_table
Copyright 1997-2012 the PHP Documentation Group. [2230]
•
mysql_field_table
Get name of the table the specified field is in
Warning
This extension is deprecated as of PHP 5.5.0, and will be removed in the
future. Instead, the
MySQLi or PDO_MySQL extension should be used. See
also MySQL: choosing an API guide and related FAQ for more information.
Alternatives to this function include:
mysqli_fetch_field_direct
[table] or [orgtable]
PDOStatement::getColumnMeta
[table]
Description
string mysql_field_table(
resource result,
int field_offset);
Returns the name of the table that the specified field is in.
Parameters
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.
Return Values
The name of the table on success.
Examples
Example 20.51. A
mysql_field_table
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