php safe mode mysql connections

[tenacious-dee]

Hi guys

I'm trying to get this bit of code reading from my db.

It works fine on my localhost but on the server, which is running php in safe mode, it
only displays the following:

Could not retrieve records:

Could abybody help me out please?? I'm at my wits end with this.

<?php 
			$mysql = mysql_connect("localhost","anmluser","8uhb2wsx","anmldb");

		if(!mysql){
			printf("Connect failed: %s\n", mysql_error());
			exit();
		}else{
		$sql = "SELECT homepage_id, page_title, page_content from tblhomepage WHERE homepage_id=4";
		$res = mysql_query($mysql, $sql);


		if($res){
			//while($newArray = mysql_fetch_array($res, MYSQL_ASSOC)){
				$title=$newArray['page_title'];
				$content=$newArray['page_content'];
				echo "<center>";
				echo "<table border='0' cellpadding='6'>";
				echo "<tr>";
				echo "<td><font color='orange' size='3pt'><b>".$title."</b></font></td>";
				echo "</tr>";
				echo "<tr>";
				echo "<td>".$content."</td>";
				echo "</tr>";
				echo "</table>";
				echo "</center>";
			//}
		}else{
			printf("Could not retrieve records: %s\n", mysql_error($mysql));
		}

		mysql_free_result($res);
		mysql_close($mysql);
		}
		?>

Thanks in advance

[sneakyimp]

You need to check for an error condition when you attempt to query your db. change this line:

           $res = mysql_query($mysql, $sql); 

to this:

           $res = mysql_query($mysql, $sql) or die('The query had a problem:' . mysql_error($mysql));

If you get a mesg 'your query had a problem' then hopefully it will give more information. It may be that you cannot connect to your database, that the table you are querying does not exist, or a variety of other problems. It's hard to tell because you don't check for error conditions when you connect or query your db.