CONTEMAN

[CONTEMAN]

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in C:\Documents and Settings\FMS\Desktop\Relencia\Website\htdocs\account\inc\confirm.php on line 64
error:

if($errors == NULL) {
echo 'Please remember this information:</br>';
echo 'Account Number: '.$_POST['account'];
echo 'Name: '.$_POST['name'].'</br>';
echo 'Password: Password not displayed for security reasons.</br>';
echo 'Email: '.$_POST['email'].'</br>';

//insert to database
$connection = mysql_connect('localhost','root','')or die('error: '.mysql_error());
if (!$connection)
	{
	die('could not connect to database: ' . mysql_error());
	}

mysql_select_db("relencia", $connect)or die('error: '.mysql_error()); 

$sql = "INSERT INTO account (accno, password, type, premDays, email, blocked, name)
VALUES 
('$_POST[account]', '$_POST[password]', '0', '0', '$_POST[email]', '0', '$_POST[name]')";
	if (!mysql_query($sql,$con))
		{
		die('Error: ' . mysql_error());
	}
mysql_close($connect);
}

enlighten me!!!!!!!!!

[NogDog]

Inconsistent variable naming:

[color=red]$connection[/color] = mysql_connect('localhost','root','')or die('error: '.mysql_error());
if (!$connection)
    {
    die('could not connect to database: ' . mysql_error());
    }

mysql_select_db("relencia", [color=red]$connect[/color])or die('error: '.mysql_error());

$sql = "INSERT INTO account (accno, password, type, premDays, email, blocked, name)
VALUES
('$_POST[account]', '$_POST[password]', '0', '0', '$_POST[email]', '0', '$_POST[name]')";
    if (!mysql_query($sql,[color=red]$con[/color]))