mysql connections

rtown

well I am officially retarded...
I am just trying to test my new MySQL connection, and through a simple test script I can connect to the host, but my programmed error message for not connecting to the database comes up. My passwords and names are correct, can anyone see something in the code?😕 the browser said that there is an error on line 10 (mysql_select_db line)

<html>
<body>
<?php
$hostname="took out for good reason😉";
$user="took out for good reason😉";
$passwd="took out for good reason😉";
$database="took out for good reason😉";

$db = mysql_connect($hostname, $user, $passwd) || die ("Error..could not connect to " . $user);
mysql_select_db($database,$db) || die ("Error..could not find " . $database);
$result = mysql_query("SELECT * FROM employees");
printf("First Name: %s<br>\n", mysql_result($result,0,"first"));
printf("Last Name: %s<br>\n", mysql_result($result,0,"last"));
printf("Address: %s<br>\n", mysql_result($result,0,"address"));
printf("Position: %s<br>\n", mysql_result($result,0,"position"));

?>
</body>
</html>

🙁 help🙁
rtown

nemonoman

2 suggestions:

ONE:
I've never seen the construction you're using:

mysql_select_db($database,$db) || die ("Error..could not find " . $database);

It might work but the one you use earlier, assigning a variable

$db = mysql_connect($hostname, $user, $passwd) || die ("Error..could not connect to " . $user);

is more standard. I'd assign a variable to your mysql_select_db

TWO:
mostly likely is a TYPO in $database. Check caps, spacing, everything; then check again.

Tell us if this helps.