What the heck am I doing wrong???
Simple situation, I use drop downs to populate dates on a form. I have a drop down for month, day and year. I store everything in the MySQL DB as yyyy-mm-dd, but on the web page I use Month day Year format. Now the user enters the date (simple enough) but then when they come back they can modify the date if they need to. To allow them to do this I first select their date information from the database...
START CODE SNIP:
php Code:
 Original
- php Code |
|
|
|
$sql1Adate = "SELECT DATE_FORMAT(ecom1,'%m') as eddate1A FROM tbl_resume_edu where UID=$UID";
$sql1Bdate = "SELECT DATE_FORMAT(ecom1,'%d') as eddate1B FROM tbl_resume_edu where UID=$UID";
$sql1Cdate = "SELECT DATE_FORMAT(ecom1,'%Y') as eddate1C FROM tbl_resume_edu where UID=$UID";
....
{
$eddate1A = $query_data1A[eddate1A];
}
while($query_data1B = mysql_fetch_arra($result1Bdate))
{
$eddate1B = $query_data1B[eddate1B];
}
{
$eddate1C = $query_data1C[eddate1C];
}
END CODE SNIP:
Now with this information I populate the various drop down boxes. The year works fine so here is an example.
START CODE SNIP:
php Code:
| Original
- php Code |
|
|
|
function ye()
{
$ye[1] = "1960";
$ye[2] = "1961";
//You get the idea
$ye[42] = "2001";
$ye[43] = "2002";
return $ye;
}
php Code:
| Original
- php Code |
|
|
|
$etest13 = ye();
echo "<select name='ed_ye1'>";
for ($i=0; $i<44; $i++){
}
END CODE SNIP:
That works just fine, and so does the day of the month. Same idea as above. Trouble is with the month. Since I am storing the month in the 2 digit format in the database I have a little function to handle the DB to Human translation, or so I thought. Here is the funtion
START CODE SNIP:
php Code:
| Original
- php Code |
|
|
|
function moTest()
{
$moTest[01] = "January";
$moTest[02] = "February";
$moTest[03] = "March";
$moTest[04] = "April";
$moTest[05] = "May";
$moTest[06] = "June";
$moTest[07] = "July";
$moTest[08] = "August";
$moTest[09] = "September";
$moTest[10] = "October";
$moTest[11] = "November";
$moTest[12] = "December";
return $moTest;
}
END CODE SNIP:
OK so when I call the variable that I have pulled from the DB as the month (for example 02 for February) I get nothing from the array. No error just a blank drop down. BUT if the variable is greater then 10 (or later in the year then October) IT WORKS!! Please see below...
START CODE SNIP:
php Code:
| Original
- php Code |
|
|
|
<?php $mtest31 = moTest();
echo "<select name='mil_train_mo3'>";
echo $mtest31[$eddate1A];
//Produces no output until $eddate1A is greater then 10 echo $eddate1A;
//echo the correct value for the stored month for ($i=0; $i<13; $i++){
}
END CODE SNIP:
Does any one see what I might be doing wrong? Or perhaps knows an alternative?
Codewalkers Forums Sponsor:
November 4th, 2002, 08:59 PM
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
