on 1/24/03 12:26 AM, amiller@xxxxxxxxxxxxxxxx purportedly said: > $date = $year . "-" . $month . "-" . $day; > insert into s_objetivos_caso values ($dni,$date,$cod_s_objetivos,$conn); > > or right in the the query itself... > > insert into s_objetivos_caso values ($dni,$year . "-" . $month . "-" . > $day,$cod_s_objetivos,$conn); > > you would need to check that second way to be sure, but the first one will > work for sure. Neither of these will work, nor any previous suggestion, as date formats are ambiguous and *must* be quoted: $date = $year . "-" . $month . "-" . $day; insert into s_objetivos_caso values ($dni,"'$date'", $cod_s_objetivos,$conn ); This *will* work, at least as far as the date is concerned. Keary Suska Esoteritech, Inc. "Leveraging Open Source for a better Internet"
