mysql_field_table
(PHP 3, PHP 4, PHP 5)
mysql_field_table -- Get name of the table the specified field is in
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 1. A mysql_field_table() example
<?php
$result = mysql_query("SELECT name,comment FROM people,comments");
if (!$result) {
echo 'Could not run query: ' . mysql_error();
exit;
}
// Assuming name is in the people table
$table = mysql_field_table($result, 'name');
echo $table; // people
?>
|
|
Notes
Note:
For downward compatibility, the following
deprecated alias may be used:
mysql_fieldtable()