Here is the database structure:
CREATE TABLE schedule_sunday (
id int(5) NOT NULL auto_increment,
0200 varchar(100) NOT NULL default '',
0400 varchar(100) NOT NULL default '',
0600 varchar(100) NOT NULL default '',
0800 varchar(100) NOT NULL default '',
1000 varchar(100) NOT NULL default '',
1200 varchar(100) NOT NULL default '',
1400 varchar(100) NOT NULL default '',
1600 varchar(100) NOT NULL default '',
1800 varchar(100) NOT NULL default '',
2000 varchar(100) NOT NULL default '',
2200 varchar(100) NOT NULL default '',
2400 varchar(100) NOT NULL default '',
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Sunday' AUTO_INCREMENT=4 ;
Here is the coding:
function staff_schedule($date,$day) {
echo "<tr><td><select name=\"$date\">";
$sql = "SELECT * FROM staff ORDER BY name ASC";
$result = mysql_query($sql);
while ($arr = mysql_fetch_array($result)) {
$sql2 = "SELECT * FROM schedule_".$day." WHERE ".$date."='$date'";
$result2 = mysql_query($sql2);
$arr2 = mysql_fetch_array($result2);
if ($arr2[0] == $arr['id']) {
echo "<option value=\"" . $arr['id'] . "\" selected>" . $arr['name'] . "</option>";
} else {
echo "<option value=\"" . $arr['id'] . "\">" . $arr['name'] . "</option>";
}
}
echo "<\select></td></td>";
}
any clue what in the world I'm doing wrong
