Women in Technology

Hear us Roar



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.

Full Threads Newest First

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.