mysql_field_table

Example 814. Find the table name for the fields in a query

<?php
// Included code that connects to a MySQL server and sets a default database
// See the MySQL Functions chapter introduction for the source code for the file
include ('mysql_connect.inc.php');

// A SELECT query using a column name and a few functions
$query = "SELECT login, UNIX_TIMESTAMP(), NOW() FROM user";

// Run the query
$mysql_result = @ mysql_query ($query)
    or die ("Query '$query' failed with error message: \"" . mysql_error () . '"');

// Grab information on every other field in the result set
// Display the object containing field information
for ($offset = 0; $offset < mysql_num_fields ($mysql_result); ++$offset) {

   // Find the name of the current field
   $field_name = mysql_field_name ($mysql_result, $offset);

   // Find the name of the table for the current field
   // If mysql_field_table() returns false, set $table_name to '?'
   $table_name = mysql_field_table ($mysql_result, $offset)
      or $table_name = '?';

   echo "Field '$field_name' belongs to table '$table_name'.<br />";
}
?>