I need a little database help

[mshaeffer]

I keep getting this error:

User 'username' has exceeded the max_questions resource (current value: 100000)

I have contacted my host and they have told me each user on the database has a limit of 100000 hits allowed in a 1 hour time period. They also said that the limit is per user. They suggested adding more users to the database and making it call to different ones if one reaches the limit. Now, I can make more users on the database, but I do not know how I would code that on my mysql.php page.

This is how the mysql.php page looks now:

<?

$c=mysql_connect('host','username','password') or die(mysql_error());

mysql_select_db('database name',$c);

?>

How would I make it so it can call to multiple usernames, in essance, raising my hourly limit by 100k per user?

[seanybob]

Re: I need a little database help

inefficient perhaps, but the first way that comes to mind.

$a=rand(1,2);

if($a==1){$user='bob';}

if($a==1){$user='frank';}

[hamster01]

Re: I need a little database help

Well, I read a bit bout this on google. :)

A few things you could try:

Closing the connection at end of script.

Ompitmizing MCCodes.(lol)

The users, as your host said.