[plug] Hash / pound prefix for mysql tables

[Steve Baker]

On 04/05/11 16:08, Shanon Loughton wrote:
> HI all
>
> Im curious if anyone knows what this means in Joomla Virtuemart 
> plugin's PHP code:
>
> "SELECT * FROM #__{vm}_user_info"
>
> What is the #__{vm}_?
>
> Does it mean its a temporary table? Or a regexp-like prefix - "look 
> for the table that has any bunch of characters then the letters 'vm'"?

In Joomla the initial #_ is the table prefix for the website, which 
normally defaults to 'jos_'.  Joomla tables have names like 
jos_blahblah, although you can specify a different prefix during 
installation.

I'm not sure what the {vm} might mean, none of the Joomla modules I use 
have anything like that.  I suspect that it is either a literal part of 
the table name, or perhaps there is a variable called 'vm' that is 
substituted into the table name.

>
> Im trying to redefine it somewhere in the config of Joomla but its not 
> a PHP variable/declaration.
>
> thanks for any help
>
> Shanon
>

Regards,
Steve