mysql_connect.. no connection and no error

[ristenk1]

This seems like it should be so easy but I am not getting an error or any result:

$connection = mysql_connect("phpexamplesite.db.4211592.hostedres ource.com", "username", "password");
if(!$connection) {

die("Database connection failed: " . mysql_error());
}


//2. Select a database to use


$db_select = mysql_select_db("username", $connection);
if(!$db_select){
die("Database selection failed: " . mysql_error());

Any ideas?

THanks

---------- Post added at 10:50 AM ---------- Previous post was at 10:42 AM ----------

I think the error is in the connection but here is the rest of it:

// 3. Perform database query
$result = mysql_query("SELECT * FROM subjects", $connection);
if(!$result){
die("Database query failed: " . mysql_error());
}

//4. Use returned data

while($row = mysql_fetch_array($result)) {
echo $row["menu_name"]. " ".$row["position"]. "<br />";
}

?>

<?php
//5. Close connection

mysql_close($connection);

?>

I'm not getting any error or results on the page...

[NetProwler]

Actually the server will crib loudly - only thing is its crib will be in the error_log. Set the PHP to show errors like this at the beginning of your script:

error_reporting(E_ALL);
ini_set("display_errors", 1);

The above will turn on reporting of errors on the browser.

[DaveSawers]

And also note that you might be getting error messages in the returned HTML but if they're not in a displayable part of the code you won't see them on the browser screen. Make sure you look at the source of the page in your browser.