Database access by table prefix

[RopeADope]

Hi all.

 

I'm working on a PHP application that will serve several clients.  After a discussion on another thread about compliance, I've decided that using tables with a client specific prefix would be the safest way to go.  However, I'm having a lot of trouble wrapping my head around what the database connection script would look like.  I have a generic one that connects with host, user, pwd, and db as arguments but I'm not sure how to modify it to incorporate the table prefix requirement.  Thoughts on how I can incorporate the aforementioned requirement and enhance the script in general?

 

function connect_mysql($host,$user,$pass,$database){
$conn=mysql_connect($host,$user,$pass)or die('Cannot create link');
mysql_select_db($database)or die('Cannot select database');
};

[vicodin]

I don't get what you mean... Nothing needs to change as far as connecting if its the same database. If your connecting to different databases then you would need to change the database name.

[RopeADope]

I might be thinking about it the wrong way, but it seems like to delineate table access by prefix I would need something in the connection script?  Or would the table access be purely on a database level?  If so, how do I restrict access on the database level?