ciao a tutti
non mi funziona l'inserimento della data nel db, mi sapete dire perchè?
--------------------------------------------------------------
<?
if ($nuovo==1){
session_start();
include ("../function.inc");
$sql = "insert into admin (username,password,nome,cognome,data) values ('$username','$password','$nome','$cognome','$data ') ";
if (mysql_query($sql, $conn)){
$msg ="nuovo utente creato";
}
}
?>
<? include('../tag_script.inc');?>
<span class="testo_blu_bold">LOGIN ADMIN FUNZIONANTE!</span>
<?
$data=$aa."-".$mm."-".$gg;
?>
<form action="<?=$PHP_SELF?>" method="post">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="50"></td>
</tr>
<tr>
<td align="center"><span class="testo_blu_bold">inserisci un nuovo utente</span></td>
</tr>
<tr>
<td align="center"><?
if ($msg) { echo "<span class=\"testo_rosso_bold\">$msg</span>";} ?></td>
</tr>
<tr>
<td height="50"></td>
</tr>
<tr>
<td><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="right"><span class="testo_nero_bold">Nome:</span></td>
<td height="25"></td>
<td width="50%" align="left"><input name="nome" type="text" class="input"></td>
</tr>
<tr>
<td align="right"><span class="testo_nero_bold">Cognome:</span></td>
<td height="25"></td>
<td width="50%" align="left"><input name="cognome" type="text" class="input"></td>
</tr>
<tr>
<td align="right"><span class="testo_nero_bold">Data di nascita:</span></td>
<td width="20" height="25"></td>
<td width="50%" align="left"><select name="gg"><?
$data=date("Y-m-d");
$anno_att=substr($data,0,4);
$mese_att=substr($data,5,2);
$giorno_att=substr($data,8,2);
$anno_par=$anno_att-50;
for ($n=1;$n<=31;$n=$n+1){
$n=sprintf("%02d",$n);?>
<option value=<?=$n?> <? if ($giorno_att==$n) { echo "SELECTED"; } ?>><?=$n?></option><?
}?></select><select name="mm">
<option value="01" <? if ($mese_att=="01") { echo "SELECTED"; } ?>>Gennaio</option>
<option value="02" <? if ($mese_att=="02") { echo "SELECTED"; } ?>>Febbraio</option>
<option value="03" <? if ($mese_att=="03") { echo "SELECTED"; } ?>>Marzo</option>
<option value="04" <? if ($mese_att=="04") { echo "SELECTED"; } ?>>Aprile</option>
<option value="05" <? if ($mese_att=="05") { echo "SELECTED"; } ?>>Maggio</option>
<option value="06" <? if ($mese_att=="06") { echo "SELECTED"; } ?>>Giugno</option>
<option value="07" <? if ($mese_att=="07") { echo "SELECTED"; } ?>>Luglio</option>
<option value="08" <? if ($mese_att=="08") { echo "SELECTED"; } ?>>Agosto</option>
<option value="09" <? if ($mese_att=="09") { echo "SELECTED"; } ?>>Settembre</option>
<option value="10" <? if ($mese_att=="10") { echo "SELECTED"; } ?>>Ottobre</option>
<option value="11" <? if ($mese_att=="11") { echo "SELECTED"; } ?>>Novembre</option>
<option value="12" <? if ($mese_att=="12") { echo "SELECTED"; } ?>>Dicembre</option>
</select><select name="aa"><?
for ($n=$anno_par;$n<=$anno_att;$n=$n+1){?>
<option value=<?=$n?> <? if ($n==$anno_att) { echo "SELECTED"; } ?>><?=$n?></option><?
}?></select></td>
</tr>
<tr>
<td align="right"><span class="testo_nero_bold">Username:</span></td>
<td width="20" height="25"></td>
<td width="50%" align="left"><input name="username" type="text" class="input"></td>
</tr>
</table></td>
</tr>
<tr>
<td><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="right"><span class="testo_nero_bold">Password:</span></td>
<td width="20" height="25"></td>
<td width="50%" align="left"><input name="password" type="password" class="input"></td>
</tr>
</table></td>
</tr>
<tr>
<td></td>
</tr>
<tr>
<td align="center"><input type="hidden" name="nuovo" value="1">
<input name="image" type="image" value="SubmitForm" src="../images/pulsante_invia.gif" width="80" height="21"></td>
</tr>
</table>
</form>
</body>
</html>