date problem

[osheriff]

I am trying to add a date into mysql db using php variables (code below). This works for all the days that are 10 or over, when they are 9 or lower it becomes an invalid date type as mysql needs date in 0000-00-00 and my code gives it in 0000-00-0.

<?php

$time=$hour.$minute.$sec;
$date=$year.$month.$day;

if($username) {

$sql="insert into meetings (username, mdescription, date, time) values ('$username', '$describe', '$date', '$time')";
$result= mysql_query("$sql");
}
?>

*This is part of the form****
Select a day:
<select name=day><option> <?php echo $currday;?> </option>

<?php

while ($firstday <=31) {
print ("<option value =$firstday>$firstday</option>");

$firstday++;

}
?>

[[deleted]]

looks like your script gives that date to SQL as YYYYMMDD, not YYYY-MM-DD. Try adding the '-' signs before sending it to SQL.

[Anon]

No. they are doesn't matter. Date must be fixed-length format, not 2002-2-9, but 2002-02-09.
$date_for_sql=sprintf('%04d-%02d-%02d',$year,$month,$day);

[[deleted]]

The date is not fixed length if you use hyphens.

2001-1-1 is perfectly ok, you don't have to change it to 2001-01-01 (why else do you think they need the hyphen in there?)

But without the hyphens a date like 2001-1-1 becomes 200111, which could be 2001-1-1 or 2001-11-somethingmissing or 2001-somethingmissing-11

$date_for_sql = $year.'-'.$month.'-'.$day;