Trying to make an alarm clock for events.
$days = array(Monday => Monday, Tuesday => Tuesday, Wednesday => Wednesday, .....);
$times = array('12 AM'=>'00:00:00', '1 AM'=>'01:00:00', '2 AM'=>'02:00:00', '3 AM'=>'03:00:00', '4 AM'=>'04:00:00'...);
These arrays populate the select fields.
So I run a query and for each 'event' returned I want to insert a new table row with two select fields like so...
while($row=mysql_fetch_array($result)){
$alarmday = $row["day"];
$alarmstart = $row["time"];
$alarmend = $row["endtime"];
$ev = $row["event"];
echo "<tr><td><label>" . $ev . "</label></td><td><select name=\"arr[ ]\" class=\"inputsm\"><option value=\"\" id=\"\">Choose One</option>";
foreach($days as $day => $day_name){
echo "<option value=\"$day\" ";
if($day_name==$alarmday){
echo "selected=\"$day\"";
}
echo ">$day_name</option>";
}
echo "</select></td>";
echo "<td><select name=\"start[ ]\" class=\"inputsm\"><option value=\"\">Choose One</option>";
foreach($times as $digital => $standard){
echo "<option value=\"$standard\" ";
if($standard==$alarmstart){
echo "selected=\"$standard\"";
}
echo ">$digital</option>";
}
echo "</select></td>";
echo "<td><select name=\"end[ ]\" class=\"inputsm\"><option value=\"\">Choose One</option>";
foreach($times as $digital => $standard){
echo "<option value=\"$standard\" ";
if($standard==$alarmend){
echo "selected=\"$standard\"";
}
echo ">$digital</option>";
}
echo "</select></td></tr>";
}
So this query is running inside a <form> field. I lost myself as to how to name the fields and also how to word the update query. Any help is MUCH appreciated! Thanks!
