PHP Form Isn’t Inserting into Database

I have written this PHP script but it is not working. I also [b][u]do not know how to record the date and time of the form’s submission[/u].[/b] Any ideas? I have to insert the date & time into the ‘signups’ table with the attribute name ‘reg_submit_date’.

[code]
<?php

$host=”localhost”; // Host name
$username=”studentac”; // Mysql username
$password=”pimmsnumber1″; // Mysql password
$db_name=”database_test”; // Database name
$tbl_name=”signups”; // Table name

// Connect to server and select database.
mysql_connect(“$host”, “$username”, “$password”)or die(“cannot connect”);
mysql_select_db(“$db_name”)or die(“cannot select DB”);

// Get values from form
$firstname=$_POST[‘firstname’];
$lastname=$_POST[‘lastname’];
$total_payable=$_POST[‘total_payable’];

// Insert data into mysql
$sql=”INSERT INTO $tbl_name(firstname, lastname, total_payable)VALUES(‘$firstname’, ‘$lastname’, ‘$total_payable’)”;
$result=mysql_query($sql);

// if successfully insert data into database, displays message “Successful”.
if($result){
echo “Successful!”;
echo “<BR>”;
}

else {
echo “Error occured”;
}

// close connection
mysql_close();
?>
[/code]

Also in #PHP _↴