First, please don't post your actual username and password. I removed them for you.
You can probably tell b/c I changed your fourth parameter to $new_link that something's wrong there, and you'd be right. That's supposed to be a boolean value (see the documentation here
PHP: mysql_connect - Manual ).
To connect to a database, use the sample code shown below:
Quote:
|
Originally Posted by http://us2.php.net/manual/en/function.mysql-select-db.php PHP Code:
<?php
$link = mysql_connect('localhost', 'mysql_user', 'mysql_password');
if (!$link) {
die('Not connected : ' . mysql_error());
}
// make foo the current db
$db_selected = mysql_select_db('foo', $link);
if (!$db_selected) {
die ('Can\'t use foo : ' . mysql_error());
}
?> |
The only other thing I see is the missing semicolon on the last line. It should be
PHP Code:
mysql_query("INSERT INTO hoursworked (firstname, mon, tue)
VALUES ('mike', '6 hours', '4 hours')");