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,LastName)
VALUES (
'{$FirstName}',
'{$LastName}'
)";

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


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

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



#Close the mysql connection
mysql_close($dbLink);

[/PHP]

[pbmods]

Heya, ddtpmyra.

Try checking for error this way:

if( mysql_errno() )
{
  exit(mysql_error());
}
 

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_error());
} [/PHP]

[Dormilich]

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

[ddtpmyra]

Thanks Dormilich for the additional info