udate command SQL Error

[ddtpmyra]

I have this below script and mysql didn't get thru I tried to print the sql query every things is fine it's just somehow can't update my table. What's wrong?

[PHP]
# Gather all required data
$FirstName = $_POST['FirstName'];
$LastName = $_POST['LastName'];

# INSERT SQL query
$query="INSERT INTO contact (FirstName,Last Name)
VALUES (
'{$FirstName}',
'{$LastName}'
)";

echo "$query";
# Execute the INSERT QUERY
$result = mysql_query($qu ery, $dbLink) ;


if($result){
echo "Successful<BR> ";

}
else {
echo "ERROR";
}
mysql_close();



#Close the mysql connection
mysql_close($db Link);

[/PHP]

[pbmods]

Heya, ddtpmyra.

Try checking for error this way:
[code=php]
if( mysql_errno() )
{
exit(mysql_erro r());
}
[/code]

http://php.net/mysql_errno

http://php.net/mysql_error

[Dormilich]

there might be something wrong with the connection resource. check if $dbLink is valid.

regards

[ddtpmyra]

hi pbmods,

Your syntax works I was able to catch what's my sql error is....

thanks a lot!

[PHP]if( mysql_error() )
{
exit(mysql_erro r());
} [/PHP]

[Dormilich]

additional note:
another common way to catch a db error is
[PHP]mysql_query($sq l) or die("DB Error " . mysql_errno() . ": " . mysql_error());[/PHP]

[ddtpmyra]

Thanks Dormilich for the additional info