Cannot make SQL connection - new ipower hosting platform

mrbrown

Ipowerweb migrated me over to their new platform. Unfortunately I am unable to link to my mySql databases:

<?
$username="gatekeep_******";
$password="*******";
$database="gatekeep_mymedia";

mysql_connect(gatekeep.accountsupportmysql.com,$username,$password);
@mysql_select_db($database) or die( "<BR><BR><B>Error: Could not establish connection");

$query="SELECT * FROM PICTURES ORDER BY TITLE";
$result=mysql_query($query);
$num=mysql_numrows($result);

?>

Can someone please let me know if there is something wrong with my connection string? This was an easy connection before when it was local- but now with the migration I can't seem to make any connections.

Thank you........

sandthipe

what is the new platform? did they upgrade from php4 to php5 or is it a MySQL upgrade, apache Upgrade, all 3? for starters, I would try a different connection script; ideally, your host should provide you with information on how to connect to your databases. Try this: set up all of your variables in php variables.

$host = "gatekeep.accountsupportmysql.com";
$user = "gatekeep_***"";
$pass = "****";
$database = "gatekeep_mymedia";

//connect to database
$connection = @mysql_connect($host, $user, $pass);

//select a database to work with
$selected = @mysql_select_db($database, $connection);

include this in the top of each php page that needs a connection to the db.

mrbrown

Thanks sandthipe.

Actually their support got back to me in less then 8 hours with the same response and it worked. This issue is resolved!

bradgrafelman

Note that the problem with your original code is that gatekeep.accountsupportmysql.com is a string and thus must be quoted as all other strings are. See the manual about what a [man]string[/man] is for more information.

Either way, don't forget to mark this thread resolved.