Hey i have a form which enters data using php into a mysql database.
i need the form to start to record the date of when the entry was made. on the MySql side i can do a timestamp and when i enter a record via phpmyadmin it does it automatically for me... but i don't know how to implement this into the php side so a user doesn't have to enter the date or even see an entry/box for the date but the date gets recorded automatically with the entry...
hope i've made sense - any help would be great!
ta
Joey - i've tried both your methods and i can't seem to get them to work...
here is my code
CONTACT.PHP
<form id="form1" name="form1" method="POST" action="contactaction.php">
<table width="650" align="center" border="2" cellpadding="2" class="form">
<tr>
<td><div align="center">Name:</div></td>
<td><div align="left">
<input type="text" name="name" id="name" />
</div></td>
</tr>
<tr>
<td><div align="center">Email Address:</div></td>
<td><div align="left">
<input type="text" name="email" id="email" />
</div></td>
</tr>
<tr>
<td><div align="center">Reason for contact</div></td>
<td><label>
<div align="left">
<select name="reason" id="reason">
<option value="General Enquiry">General Enquiry</option>
<option value="Thinking about coming to the University">Thinking about coming to the University</option>
<option value="About
i need the form to start to record the date of when the entry was made. on the MySql side i can do a timestamp and when i enter a record via phpmyadmin it does it automatically for me... but i don't know how to implement this into the php side so a user doesn't have to enter the date or even see an entry/box for the date but the date gets recorded automatically with the entry...
hope i've made sense - any help would be great!
ta
Joey - i've tried both your methods and i can't seem to get them to work...
here is my codeCONTACT.PHP
<form id="form1" name="form1" method="POST" action="contactaction.php">
<table width="650" align="center" border="2" cellpadding="2" class="form">
<tr>
<td><div align="center">Name:</div></td>
<td><div align="left">
<input type="text" name="name" id="name" />
</div></td>
</tr>
<tr>
<td><div align="center">Email Address:</div></td>
<td><div align="left">
<input type="text" name="email" id="email" />
</div></td>
</tr>
<tr>
<td><div align="center">Reason for contact</div></td>
<td><label>
<div align="left">
<select name="reason" id="reason">
<option value="General Enquiry">General Enquiry</option>
<option value="Thinking about coming to the University">Thinking about coming to the University</option>
<option value="About