Select Box

[thekidscareya]

I have a MySQL database that uses the datetime date type for the date_time column.

I use the DATE_FORMAT() to retrieve the different parts of the date and time:

$sql = "SELECT subject, html, id, DATE_FORMAT(date_time,'%c') AS month, DATE_FORMAT(date_time,'%e') AS day, ";

$sql .= "DATE_FORMAT(date_time,'%Y') AS year, DATE_FORMAT(date_time,'%l') AS hour, DATE_FORMAT(date_time,'%i') AS minute, ";

$sql .= "DATE_FORMAT(date_time,'%p') AS ampm ";
$sql .= "FROM `tbl_calendar` WHERE `id` = '".$_GET['id']."' LIMIT 1";

In my edit form...I have the fields like this:
Subject - Textbox
HTML - Textbox
Year - Dropdown
Month - Dropdown
Day - Dropdown
Hour - Dropdown
Minute - Dropdown
Ampm - Dropdown

I was wondering how I set the default value of the dropdown menus to display what the query returns.

Eg: If the date_time field returns 2005-08-09 11:00:00, then the default value for year would be 2005, month 8, day 09, etc.

How would I do that?

Thanks for all your help in advance.

[devinemke]

a simple example:

$time['year'] = range(1970, 2038);
$time['month'] = range(01, 12);
$time['day'] = range(01, 31);
$time['hour'] = range(01, 12);
$time['minute'] = range(00, 59);
$time['ampm'] = array('AM', 'PM');

$result = mysql_query("SELECT 
DATE_FORMAT(NOW(),'%Y') AS year,
DATE_FORMAT(NOW(),'%m') AS month,
DATE_FORMAT(NOW(),'%d') AS day, 
DATE_FORMAT(NOW(),'%h') AS hour,
DATE_FORMAT(NOW(),'%i') AS minute,
DATE_FORMAT(NOW(),'%p') AS ampm"
) or exit(mysql_error());

$row = mysql_fetch_assoc($result);

echo '
<form action="" method="POST">
the current date/time is:<br><br>
';

foreach ($time as $key => $value)
{
	echo $key . '<br><select name="' . $key . '">';
	foreach ($value as $subvalue)
	{
		if ($key == 'month' || $key == 'day' || $key == 'hour' || $key == 'minute') {$subvalue = sprintf('%02s', $subvalue);}

	echo '<option';
	if ($subvalue == $row[$key]) {echo ' selected';}
	echo '>' . $subvalue;
}
echo '</select><br><br>';
}

echo '</form>';

[thekidscareya]

the code worked well....thanks for that (much appreciated)

but i have one more question regarding formatting
how do i format it so that it comes out like this:

Date: || / || / ||
Time: || : || ||

WHERE |___| is the respective dropdown menu

How do i do that?

[devinemke]

use the appropriate HTML formatting

[kakki]

<form>
<table>
<tr>
<td>DATE:</td><select> .... </select></td> /
<td> ....
</tr>
<tr>
<td> ... </td> ...
</tr>
</table>
</form>

[thekidscareya]

devinemke wrote:

use the appropriate HTML formatting

im confused...how's that possible....im using a foreach() to display the form...how do i tell it to put the "/" after the month and day field, etc.

sorry for my inexperience