Hi
The field for entering the latter part of the year ie. 19XX was just another way I was trying to get it to work, but without any luck. I have since reverted back to the drop-down box style as Doc suggested.. better to try and fix a problem than create more problems. 
The script is as follows:
PHP Code:
<?php if (isset($_POST['submit'])) { // a new member joins using the form below
// START FORM VALIDATION
}
else {
echo $_POST["day"];
echo $mDOB;
// generate and execute query ONLY IF VALIDATION IS ALL TRUE
$query = "INSERT INTO Members SET
mForename = '".$_POST['Forename']."',
mSurname = '".$_POST['Surname']."',
mEmail = '".$_POST['EMail']."',
mGender = '".$_POST['Gender']."',
mDOB = '".$_POST['mDOB']."',
mHasChildren = '".$_POST['Children']."',
mSmokes = '".$_POST['smoking_select']."',
mDrinks = '".$_POST['drinking_select']."',
mAboutYourself = '".$_POST['aboutyourself']."',
mAboutFamily = '".$_POST['aboutfamily']."',
mJoinDate = now(),
mUsername = '".$_POST['Username']."',
mPassword = '".$_POST['encrypted_password']."'";
$result = mysql_query($query) or die ("Error in query: $query. " . mysql_error());
$memberID = mysql_insert_id();
// generate and execute query 2
...
$result2 = mysql_query($query2) or die ("Error in query 2: $query2. " . mysql_error());
}
} else {
// DROP-DOWN BOX QUERIES
?>
<FORM NAME="mainform" ACTION="<?php echo($_SERVER['PHP_SELF']); ?>" METHOD="POST">
<TR VALIGN="middle">
<TD>Date Of Birth:</TD>
<!-- DAY -->
<TD><SELECT NAME="day" class="formselect" />
<OPTION SELECTED VALUE="">Select</OPTION>
<?php
for ($day = 1; $day <= 31; $day++) {
if ($day<10) {
$day = "0".$day;
}
echo "<option value=\"".$day."\">".$day."</option>\n";
}
?>
</SELECT>
<!-- MONTH -->
<SELECT NAME="month" class="formselect" />
<OPTION SELECTED VALUE="">Select</OPTION>
<?php
$today = getdate();
$thismonth = 1;
for ($x=$thismonth;$x<13;$x++) {
echo "<option value=\"".date("m", mktime(0,0,0,$x,1,0))."\">".date("F", mktime(0,0,0,$x,1,0))."</option>\n";
}
?>
</SELECT>
<!-- YEAR -->
<SELECT NAME="year" class="formselect" alt="select" />
<OPTION SELECTED VALUE="">Select</OPTION>
<?php
$todayyear = $today['year'];
for ($year = 1927; $year <= $todayyear-18; $year++) {
echo "<option value=\"".$year."\">".$year."</option>\n";
}
?>
</SELECT>
</TD>
</TR>
<?php
$day = $_POST["day"];
$month = $_POST["month"];
$year = $_POST["year"];
$mDOB = $year."/".$month."/".$day;
?>
So what do you think it may be? 
Thanks.
Mak 
Bookmarks