date field in MySQL interface

[george123456724]

Hi,

I must stress I don't know *anything* about PHP coding!

I am using a PHP MySQL interface. The date field for new entries is split into selection lists for day (00 to 31), month (00 to 12) and year (currently 2002 to 2005). I want to change the code to allow me to choose between 2002, 2003, 2004, 2005 and also 0000 - giving the option of an unspecified year in my database.

The code in the php script for generating the year selection box is shown below. The values for start_year and end_year are obtained from a config.php file, which I can easily edit.

Can anyone tell me how I can change the script to get non-sequential values into this selection box as explained above?

_________________

for ($i=$start_year; $i<=$end_year; $i++){
        $year_select .= &quot;<option value=\&quot;$i\&quot;&quot;;
        if($year != &quot;&quot; and $year == $i){
            $year_select .= &quot; selected&quot;;
        } // end if
        $year_select .= &quot;>$i</option>&quot;;
    } // end for

__________________

Many thanks

George

 

[devnull22]

try this :

$year_select .= &quot;<option value=0000>0000</option>&quot;;
$year_select .= &quot;<option value=0001>0001</option>&quot;;
// well ... you get the idea now.

for ($i=$start_year; $i<=$end_year; $i++){
$year_select .= &quot;<option value=\&quot;$i\&quot;&quot;;
if($year != &quot;&quot; and $year == $i){
$year_select .= &quot; selected&quot;;
} // end if
$year_select .= &quot;>$i</option>&quot;;
} // end for

cheers
devnull22

http://www.mygolfrecord.com

http://www.kbcenter.com

(Knowledge Base Center )


--
Apparently if you play the Windows NT CD backwards you hear satanic messages. If you think that's bad, play it forwards and it installs Windows NT !