table name

[Anon]

Hi, I'm running a query on a mysql database using php. That works, however I'd like to find out how I can make php display the name of the table that it is currently accessing.
Yes, the query is only accessing one table, but because there will be more than one table, I'd like to know how I can do it dynamically.
Thanks in advance,
Richard

[jamie_webstart]

keep the dynamic table name in a variable called $tablename, and echo that. To use it in a MySQL query, just use the format: mysql_query("SELECT * FROM $tablename");

Hope that helps.

[Anon]

Thanks, that works, however do you know of a function, or a script that can get the table name, and display it?