ALTER TABLE 顧客マスタ ADD 誕生日 DATE

<TR>
	<TD class=MyCell>誕生日</TD>
	<TD class=MyCell>
		<SELECT name=In1Yyyy><?= $Yyyy ?></SELECT>年
		<SELECT name=In1Mm><?= $Mm ?></SELECT>月
		<SELECT name=In1Dd><?= $Dd ?></SELECT>日
	</TD>
</TR>

# **********************************************************
# 顧客入力画面の編集
# **********************************************************
function EditMain( ) {

	global $Yyyy,$Mm,$Dd;

	$Yyyy = "";
	for( $i = 1950; $i <= 2004; $i++ ) {
		$Work = "";
		if ( $_POST['In1Yyyy'] == $i ) {
			$Work = "selected";
		}
		$Yyyy .= "<OPTION value=\"$i\" $Work>$i\n";
	}
	$Mm = "";
	for( $i = 1; $i <= 12; $i++ ) {
		$Work = "";
		if ( $_POST['In1Mm'] == $i ) {
			$Work = "selected";
		}
		$Mm .= "<OPTION value=\"$i\" $Work>$i\n";
	}
	$Dd = "";
	for( $i = 1; $i <= 31; $i++ ) {
		$Work = "";
		if ( $_POST['In1Dd'] == $i ) {
			$Work = "selected";
		}
		$Dd .= "<OPTION value=\"$i\" $Work>$i\n";
	}


}

# **********************************************************
# ビュー
# **********************************************************
switch( $_POST['GNO'] ) {
	case PASS_初期画面:
		EditMain();
		require_once( VIEW_顧客入力 );
		break;

	case PASS_顧客入力:
		CreateInData( );
		EditData2();
		require_once( VIEW_確認画面 );
		break;

	case PASS_確認画面:
		require_once( VIEW_最終画面 );
		break;

	default:
		EditMain();
		require_once( VIEW_顧客入力 );
		break;

}

<TR>
	<TD class=MyCell>誕生日</TD>
	<TD class=MyCell>
		<?= $_POST['In1Yyyy'] ?>年
		<?= $_POST['In1Mm'] ?>月
		<?= $_POST['In1Dd'] ?>日
	</TD>
</TR>

# **********************************************************
# データベースへの更新
# **********************************************************
function InsertData( &$SQL ) {

	global $ErrMessage;

	$Query = "insert into 顧客マスタ";
	$Query .= " values(";
	$Query .= Ss( $_POST['In1Email'] );
	$Query .= "," . Ss( $_POST['In1Name'] );
	$Query .= "," . Ss( $_POST['In1Zip'] );
	$Query .= "," . Ss( $_POST['In1Address'] );
	$Query .= "," . $_POST['In1Sex'];
	$Query .= "," . Ss( $_POST['In1Tel'] );
	$Query .= "," . Ss( $_POST['In1Mobile'] );
	$Query .= "," . Ss( $_POST['In1Pass1'] );
	$Query .= ",";
	$Query .= "'";
	$Query .= $_POST['In1Yyyy'] . "/";
	$Query .= $_POST['In1Mm'] . "/";
	$Query .= $_POST['In1Dd'];
	$Query .= "'";
	$Query .= ")";

	if ( !$SQL->Execute( $Query ) ) {
		$ErrMessage = "登録に失敗しました";
		return FALSE;
	}

	return TRUE;
}