mysql random/php help

joey3002

i have a php script, that i am trying to randomly choose which mysql server to connect to.

$hosts = array ('10.0.0.6', '10.0.0.5', '10.0.0.4');
$rand_keys = array_rand($hosts);
$sqlh = mysql_connect($hosts[$rand_keys[0]], 'USERNAME', 'PASSWORD');

it does not seem to be connecting.. not sure what is wrong: in the page, i see this:

Warning: mysql_connect(): Can't connect to MySQL server on '1' (22) in /home/test.php on line 35
Warning: mysql_connect(): Can't connect to MySQL server on '7' (22) in /home/test.php on line 35

Any help would be very helpful.
Thanks

Drakla

You're using array_rand wrong change your connect to

mysql_connect(array_rand($hosts), 'USERNAME', 'PASSWORD');

joey3002

getting there.. still not working:

Warning: mysql_connect(): Can't connect to MySQL server on '4' (22) in /home/joetest.php on line 5

then i run it again:

Warning: mysql_connect(): Can't connect to MySQL server on '2' (22) in /home/joetest.php on line 5

joey3002

ok, getting closer:

$hosts = array ("10.0.0.6", "10.0.0.4");
$rand_keys = array_rand($hosts);

$sqlh = mysql_connect($input[$rand_keys[0]], 'USERNAME', 'PASSWORD');
mysql_select_db(DB);

it seems like its not connected to the right db. I know the user/pass is right. and the db name is right.. am i missing something here and making a dumb mistake somewhere?

again, it now connects to the server but seems like its not getting the right db.

thanks