mysql_connect problems

[murpsoft]

Hi, I tried doing things the PHP standard way for connecting to the MySQL DB here on Powweb and that's not working.

Error:

No database selected

$link = mysql_connect('mysql05.powweb.com',$sql_username,$ sql_password);
$sql = "INSERT INTO `members` (`username`, `email`, `password`, `expires`) VALUES ('$username', '$email', '$password', '$date')";
mysql_query($sql,$link);

The database exists and such, just curious what I'm doing wrong?

[tbonekkt]

$link = mysql_connect('mysql05.powweb.com',$sql_username,$ sql_password);
$sql = "INSERT INTO `members` (`username`, `email`, `password`, `expires`) VALUES ('$username', '$email', '$password', '$date')";
mysql_query($sql,$link);You don't have a DB select:$result = mysql_select_db("<database_name_here>") or die("Error selecting database");So your full code would look something like this:$link = mysql_connect('mysql05.powweb.com',$sql_username,$ sql_password);
$result = mysql_select_db("<database_name_here>",$link) or die("Error selecting database");
$sql = "INSERT INTO `members` (`username`, `email`, `password`, `expires`) VALUES ('$username', '$email', '$password', '$date')";
mysql_query($sql,$link);