Article:		Using MySQL from PHP
Subject:		Connect to MySQL DB
Date:		2007-12-15 08:23:06
From:		krsbuilt
Response to: Connect to MySQL DB
Your Problem is that the database connection isn't using the mysql connection. If you did it like this: mysql_connect($hostname,$username, $password) or die ('Error connecting to mysql'); mysql_select_db($dbname); it might work. since you were making the mysql cnnection a variable, your database connection couldn't use it. now if you make the mysql connection not a variable then anything in the script can access it.

Showing messages 1 through 2 of 2.

• Connect to MySQL DB
  2009-06-22 20:04:54  mfoster978 [View]
  
  
  I need help. I have been working on my site for days now and am having a problem. I am receiving an error saying the script could not connect to my sql. My script seems perfectly fine but it won't connect. Also I am using godaddy and a windows hosting account. Is there a chance it won't connect unless I change to linux?
  
  My script is below:
  
  
  <?
  /**
  * Connect to the mysql database.
  */
  $conn = mysql_connect("p3nlmysqladm001.secureserver.net:", "loginform978", "************") or die(mysql_error());
  mysql_select_db('loginform978', $conn) or die(mysql_error());
  
  ?>
  
  
  I have also tried this:
  <?
  /**
  * Connect to the mysql database.
  */
  $conn = mysql_connect("p3nlmysqladm001.secureserver.net:3306", "loginform978", "************") or die(mysql_error());
  mysql_select_db('loginform978', $conn) or die(mysql_error());
  
  ?>
  
  Please help me. If you need to please contact me at mike_foster@tmail.com.
  
  Thanks,
  Mike Foster
• Connect to MySQL DB
  2009-07-05 20:17:09  Reloaded2010 [View]
  
  
  Remove the colon : after the server name. Use just p3nlmysqladm001.secureserver.net and you should be ok.