Serious MySQL problems I've never had before...

mitcho

I have just received the following problems:

Warning: mysql_connect(): Can't connect to MySQL server on 'caelum.netregistry.com.au' (10061) in D:\SITES\CROWTHER\new\includes\DisplayFunctions.php on line 885

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in D:\SITES\CROWTHER\new\includes\DisplayFunctions.php on line 886
unable to find db

line 885 is
$db=mysql_connect(HOST,USER,PASS);

line 886 is
$SQL = "SELECT Title, VesselID, Thumbnail FROM vessel WHERE BrokerageID = '0' AND Category ='".$category."' ORDER BY Title";

$RS = mysql_query($SQL, $db);

  while($row = mysql_fetch_object($RS)){

…

}[/COLOR]

Variables HOST, USER, PASS are defined further above. I have checked these details work by connecting to the database using MyCON mySQL GUI.

devinemke

what does [man]mysql_error[/man] have to say about your connection routine?

mitcho

im using a home server running php to connect to an online mysql database. the connection works because i can connect to the database manually.

i was using php 5.05 when the problem occured.

i then went back to a previous 4 version problem still exists..

has anyone come accross this problem before or know why i would be having this problem?

devinemke

my question still stands

mitcho

I will check and get back to you very soon, thanks for helping...

do you think it could be a problem that there are no dollar signs in front of the variable names HOST, USER, PASS and MYDB. When there's no dollar sign i think it passes them as a string literal. is this correct?

devinemke

mitcho wrote:
do you think it could be a problem that there are no dollar signs in front of the variable names HOST, USER, PASS and MYDB. When there's no dollar sign i think it passes them as a string literal. is this correct?

no. if you don't use $'s and don't use quotes then PHP assumes that they are constants. have you defined those constants? again, hate to sound like a broken record but using the proper error reporting would go a long way in debugging.

Rodney_H_

It appears from that error that you are not selecting a database. You don't have a "mysql_select_db" statement.

<?php
// connect to database
$db = mysql_connect("localhost","user_name") or die("Unable to connect");
// select database
mysql_select_db("your_db",$db);
// sql query
$sql = "SELECT * FROM Article WHERE id=1";
// blah, blah, blah...
?>