Posted by Mike Smith on 01/10/06 18:53

On 1/10/06, Sue <skot1@twcny.rr.com> wrote:
> Hello,
>
> We have a form that contains a Select option for a listing of available
> dates for the user to choose from. Right now we have to manually change the
> dates within the form's Selection list as new dates become available to
> choose from. We currently store these available dates in our database, and
> am wondering if we can somehow extract these dates from the table to display
> in our form? This would eliminate alot of maintenance needed to this form.
> If anyone has any ideas as to reference material etc. that I may look which
> would give me an idea how to do this using PHP, I'd appreciate it!
How about...

$format = "m/d/Y";
$sql = "SELECT datefield FROM table";
$results = $whatever_db_abstraction_your_using_to_execute__sql($sql);

<select name="date">
<?php
foreach($results AS $result){
echo "<option>".date($format,strtotime($result))."</option>";
}
?>
</select>

http://us2.php.net/manual/en/function.strtotime.php
http://us2.php.net/manual/en/function.date.php

Mike

• Next in forum: Re: [PHP] Is there a way to display data from database for Select Options in a form?
• Prev in forum: RE: [PHP] replacing .shtml #exec cgi with php calls
• Thread view: Re: [PHP] Is there a way to display data from database for Select Options in a form?

[Reply to this message]