email form (newsletter)

[Anon]

I have a simple form on my page which consist of one filed named "email" When I submit the value to my database only the email address is being added. I would like to add the date and recordid as well.

My table name is "ltnews" and consists of three field names (EntryDate, RecordID, email)

Below is the INSERT php code.

<?php
$connection = mysql_connect (localhost, laketrav_mktgman, quest57) or die ("Unable to connect!");

							mysql_select_db (laketrav_360info); 

							if( !empty($ltnews) )
							{ 
							$result = mysql_query ("INSERT INTO ltnews (email) VALUES ('$ltnews')"); 
							} 
						  ?>

Any suggestions?

Thanks - Mark

[siwis]

INSERT INTO ltnews VALUES (NOW(), '', '$ltnews')

This assumes that your field EntryDate is a date/time function field.