PHP - MySQL - Inserting Data

[kokatepranot]

I have a form with two fields - firstname and lastname. I am trying to insert data into my mysql database, but unable to do so!! Can someone help please! Following is the script on my action1.php file

<?php $username="";
$password="";
$database="***";

$firstname=$POST['firstname'];
$lastname=$POST['lastname'];

mysql_connect(***,$username,$password);
@mysql_select_db($database) or die("Unable to select database");
$query = "INSERT INTO pko_userinfo (firstname, lastname) VALUES ('$firstname', '$lastname')";
mysql_query($query);

mysql_close();
?>

[bastien]

add some debug code

mysql_connect(***,$username,$password)or  die("Unable to connect ".mysql_error());
mysql_select_db($database) or die("Unable to select database");
$query = "INSERT INTO pko_userinfo (firstname, lastname) VALUES ('$firstname', '$lastname')";
mysql_query($query)die("Error in query ".mysql_error());