How to get current database tablename/table prefix?

[chrisssy]

Hello everyone.

How can I get the current database table name and prefix?

[Vernier]

Do you mean you want to get the table prefix name, like this:

tableprefix_users ?


If that is correct, you can use the TABLE_PREFIX code.

TABLE_PREFIX

[chrisssy]

Do you mean you want to get the table prefix name, like this:

tableprefix_users ?


If that is correct, you can use the TABLE_PREFIX code.

TABLE_PREFIX

Correct, I'm guessing that is a PHP constant? Thank you for your help.

[Vernier]

What are you trying to do with it?

For example, if you're running a query, you'd use something like this:

$db->query("UPDATE `".TABLE_PREFIX."users` SET email='1' WHERE uid='1'");