From: "Adrian Donoiu" <a.donoiu@xxxxxxxxx> > I need information about how can I get the table name from this query : > select * from test_table as t > when I use : > $field=mysql_fetch_field($result, $i); > $field->table return the name of the table as "t" but I need the real > name of the table "test_table". > How can I do it? You can't. If you alias the table as "t", then that's the table name. Either don't use an alias or write a function that'll parse the query to retrieve the table name. ---John Holmes... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php