Jump to content

Archived

This topic is now archived and is closed to further replies.

genista

Retrieve Problem

Recommended Posts

Hi all,

I have a script to allow a user to update their details and I am stuck with pulling back the year part of the date of birth method I am using. In order to retrieve the day I use:

[code=php:0]
$dbday=$row['dbday'];
    $dbmonth=$row['dbmonth'];
    $dbyear=$row['dbyear'];

$currentValue = $row['dbday'];

//generate drop down for day
echo '<select name="dbday">';
for ($i=1; $i < 32; $i++)
{
    //adds a leading zero if needed
    //$lz = strlen($i) == 1 ? '0'.$i : $i;
    $lz = str_pad($i, 2, '0', STR_PAD_LEFT);
    // check if the value displayed is the one currenlty selected
    $checkedStatus = '';
    if ($i == $currentValue)
    {
        $checkedStatus = 'SELECTED';
    }
    echo '<option value="'.$lz.'" '.$checkedStatus.'>'.$lz.'</option>';
}
echo '</select>';
[/code]

This works great. However trying to do something similar for the year doesnt work:

[code=php:0]
//year
$currentvalue3 = $row['dbyear'];

echo '<select name="dbyear">';
for ($i=1900; $i < 2006; $i++)
{
//adds a leading zero if needed
$lz = strlen($i) == 1 ? '0'.$i : $i;
$checkedStatus = '';
if ($i == $currentValue3)
    {
        $checkedStatus = 'SELECTED';
    }
    echo '<option value="'.$lz.'" '.$checkedStatus.'>'.$lz.'</option>';
[/code]

Any ideas as I have been looking at this all morning...

Thanks,

G

Share this post


Link to post
Share on other sites
Define "doesn't work". Have you looked at the generated html code that the script produces?

Share this post


Link to post
Share on other sites
Ok,

I have removed the first leading zero, as it wasn't necessary, the problem is it is still not displaying the date off this code:

[code=php:0]
$currentvalue3 = $row['dbyear'];

echo '<select name="dbyear">';
for ($i=1900; $i < 2006; $i++)
{
//adds a leading zero if needed
$lz = strlen($i) == 1 ? '0'.$i : $i;
$checkedStatus = '';
if ($i == $currentValue3)
    {
        $checkedStatus = 'SELECTED';
    }
    echo '<option value='.$checkedStatus.'>'.$lz.'</option>';
    //echo '<option value="'.$lz.'" '.$checkedStatus.'>'.$lz.'</option>';
}
echo '</select>'; 
[/code]

Thanks,
G

Share this post


Link to post
Share on other sites
[code]echo '<select name="dbyear">';
for ($i=1900; $i < 2006; $i++)
{
$checkedStatus = '';
if ($i == $currentValue3)
    {
        $checkedStatus = 'SELECTED';
    }
    echo '<option value="'. $lz. '" selected=".$checkedStatus.'">'.$lz.'</option>';
}
echo '</select>'; [/code] 

Share this post


Link to post
Share on other sites
Thanks AndyB

But that line:[code=php:0]echo '<option value="'. $lz. '" selected=".$checkedStatus.'">'.$lz.'</option>';[/code]

Gives me the following error: parse error, unexpected '\"', expecting ',' or ';'

Taking ou some of the marks still leaves me with the list being populated with '12'.

Share this post


Link to post
Share on other sites
My fault - too much speed, not enough coffee. This works:

[code]echo '<select name="dbyear">';
for ($i=1900; $i < 2006; $i++)
{
$checkedStatus = '';
if ($i == $currentValue3)
    {
        $checkedStatus = 'SELECTED';
    }
    echo '<option value="'. $i. '" selected="'. $checkedStatus. '">'. $i.'</option>';
}
echo '</select>'; [/code]

Share this post


Link to post
Share on other sites
Ok, I have solved the problem, it was a capital V in currentvalue that was causing the problem.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.