MySQL Returning No Results

Discussion in 'Site & Server Administration' started by quicksilver101, Feb 29, 2008.

  1. #1
    Hi there,

    I've set up a new website with SteadFast Networks in the past 48hrs. The trouble is my website can't return any MySQL results. The script is fine. When i run the same script in the phpMSQL app in the control panel it returns the results. Im confused!? I've contacted the support team and they've asked my to check my connectoin script but im sure its ok...

    mysql_connect(localhost,user,*******);

    mysql_select_db(database);

    Its getting tedious now..

    Regards.
     
    quicksilver101, Feb 29, 2008 IP
  2. gate2vn

    gate2vn Peon

    Messages:
    809
    Likes Received:
    33
    Best Answers:
    1
    Trophy Points:
    0
    #2
    as far as I know, Steadfast use H-Sphere control panel, and it's a cluster control panel. Make sure you have mysql running on the same server, otherwise, you will need to change your mysql_connect from localhost to the IP of database server
     
    gate2vn, Feb 29, 2008 IP
  3. maestria

    maestria Well-Known Member

    Messages:
    705
    Likes Received:
    8
    Best Answers:
    0
    Trophy Points:
    110
    #3
    ask the server admins to run a flush host in case you are trying to connect to mysql from a remote location.
     
    maestria, Feb 29, 2008 IP
  4. quicksilver101

    quicksilver101 Peon

    Messages:
    123
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #4
    Indeed they run MySQL on a different server! Silly me! Thank you gate2vn and maestria.
     
    quicksilver101, Mar 1, 2008 IP