[blessedrub]

I have trying to send the date to my database along with other information that is being inserted. Could someone PLEASE assist me.

My declarations are as follows...
$Phone = $_POST["Phone"];

This is my query statement
$Query="INSERT INTO $TableName (Amount,FirstName,LastName,Address,Email,Phone,Dat e) VALUES ('$_POST[Amount]','$_POST[FirstName]','$_POST[LastName]','$_POST[Address]','$_POST[Email]','$_POST[Phone]')";

How can I send the date along with the data being entered?
Grateful for help

[OnlineDesignz]

Hello,

First you need to create a mysql connection then you can use the mysql_query function. You will need a new row in the database for the date to be entered you can do this using the built in datetime row.

Here is the coding you will need below:

@mysql_query("INSERT INTO TableName (Amount, FirstName, LastName, Address, Email, Phone, Date) VALUES ('$_POST[Amount]', '$_POST[FirstName]', '$_POST[LastName]', '$_POST[Address]', '$_POST[Email]', '$_POST[Phone]', now()");

If you have any more trouble please contact me at my site: www.onlinedesignz.com (click community). I am not sure I will check back here.