adding to database

[Harbinger]

this code does not error on me...yet does not display the last echo line, nor add anything to my file...

what is going on?

<?PHP
	if (!$type || !$year || !$specs)
{
	echo "You have not entered all the required details.<br>"
		."Please go back and try again.";
	exit;
}

$type = addslashes($type);
$year = addslashes($year);
$specs = addslashes($specs);

@ $db = mysql_pconnect("localhost" , "***" , "***");

if (!$db)
{
	echo "Error: Could not connect to database. Please try again later.";
	exit;
}

mysql_select_db("surplus");
$query = "insert into surplus values
		('".$type."' , '".$year."' , '".$specs."')";
$result = mysql_query($query);
	if ($result)
		echo  mysql_affected_rows()." surplus added to the database.";
		?>

[diego25]

if ($result)

    echo  mysql_affected_rows()." surplus added to the database.";

Where's your "else" part? It's because you don't have an else statement that yo don't get any errors...

Diego

[kevinsequeira]

try this at the end ..

$result = mysql_query($query);
if (mysql_error()){
print(mysql_error()."<BR>");
print($query."<BR>");
}

you will get the error, if any ....