R0n1n66

Wow That fixed the issue, Thanks so much.

The part that is suppose to print on the page is the number next to the day of the week it is.

I see thanks. Array ( [0] => Array ( [schedule_id] => 4572 [schedule_track_id] => 50 [saved_name] => July 6-July 10 [time_stamp] => 2015-07-02 12:05:56 [employee] => Enrollment [monday] => 11 [tuesday] => 15 [wednesday] => 11 [Thursday] => 12 [friday] => 11 [class] => infants [start_date] => 2015-07-06 [end_date] => 2015-07-10 [monday_s] => y [tuesday_s] => y [wednesday_s] => y [Thursday_s] => y [friday_s] => y [monday_bold] => y [tuesday_bold] => y [wednesday_bold] => y [Thursday_bold] => y [friday_bold] => y ) [1] => Array ( [schedule_id] => 4573 [schedule_track_id] => 50 [saved_name] => July 6-July 10 [time_stamp] => 2015-07-08 10:51:31 [employee] => Enrollment [monday] => 11 [tuesday] => 0 [wednesday] => 0 [Thursday] => 12 [friday] => 10 [class] => orange [start_date] => 2015-07-06 [end_date] => 2015-07-10 [monday_s] => y [tuesday_s] => y [wednesday_s] => y [Thursday_s] => y [friday_s] => y [monday_bold] => y [tuesday_bold] => y [wednesday_bold] => y [Thursday_bold] => y [friday_bold] => y ) [2] => Array ( [schedule_id] => 4574 [schedule_track_id] => 50 [saved_name] => July 6-July 10 [time_stamp] => 2015-07-08 10:51:31 [employee] => Enrollment [monday] => 12 [tuesday] => 0 [wednesday] => 0 [Thursday] => 12 [friday] => 14 [class] => green [start_date] => 2015-07-06 [end_date] => 2015-07-10 [monday_s] => y [tuesday_s] => y [wednesday_s] => y [Thursday_s] => y [friday_s] => y [monday_bold] => y [tuesday_bold] => y [wednesday_bold] => y [Thursday_bold] => y [friday_bold] => y ) [3] => Array ( [schedule_id] => 4575 [schedule_track_id] => 50 [saved_name] => July 6-July 10 [time_stamp] => 2015-07-08 10:51:31 [employee] => Enrollment [monday] => 12 [tuesday] => 0 [wednesday] => 0 [Thursday] => 15 [friday] => 9 [class] => red [start_date] => 2015-07-06 [end_date] => 2015-07-10 [monday_s] => y [tuesday_s] => y [wednesday_s] => y [Thursday_s] => y [friday_s] => y [monday_bold] => y [tuesday_bold] => y [wednesday_bold] => y [Thursday_bold] => y [friday_bold] => y ) [4] => Array ( [schedule_id] => 4576 [schedule_track_id] => 50 [saved_name] => July 6-July 10 [time_stamp] => 2015-07-08 10:51:31 [employee] => Enrollment [monday] => 12 [tuesday] => 0 [wednesday] => 0 [Thursday] => 14 [friday] => 13 [class] => blue [start_date] => 2015-07-06 [end_date] => 2015-07-10 [monday_s] => y [tuesday_s] => y [wednesday_s] => y [Thursday_s] => y [friday_s] => y [monday_bold] => y [tuesday_bold] => y [wednesday_bold] => y [Thursday_bold] => y [friday_bold] => y ) [5] => Array ( [schedule_id] => 4577 [schedule_track_id] => 50 [saved_name] => July 6-July 10 [time_stamp] => 2015-07-08 10:51:31 [employee] => Enrollment [monday] => 14 [tuesday] => 0 [wednesday] => 0 [Thursday] => 16 [friday] => 12 [class] => purple [start_date] => 2015-07-06 [end_date] => 2015-07-10 [monday_s] => y [tuesday_s] => y [wednesday_s] => y [Thursday_s] => y [friday_s] => y [monday_bold] => y [tuesday_bold] => y [wednesday_bold] => y [Thursday_bold] => y [friday_bold] => y ) [6] => Array ( [schedule_id] => 4578 [schedule_track_id] => 50 [saved_name] => July 6-July 10 [time_stamp] => 2015-07-08 10:51:31 [employee] => Enrollment [monday] => 18 [tuesday] => 0 [wednesday] => 0 [Thursday] => 17 [friday] => 15 [class] => yellow [start_date] => 2015-07-06 [end_date] => 2015-07-10 [monday_s] => y [tuesday_s] => y [wednesday_s] => y [Thursday_s] => y [friday_s] => y [monday_bold] => y [tuesday_bold] => y [wednesday_bold] => y [Thursday_bold] => y [friday_bold] => y ) [7] => Array ( [schedule_id] => 4579 [schedule_track_id] => 50 [saved_name] => July 6-July 10 [time_stamp] => 2015-07-08 10:51:31 [employee] => Enrollment [monday] => 15 [tuesday] => 0 [wednesday] => 0 [Thursday] => 15 [friday] => 14 [class] => silver [start_date] => 2015-07-06 [end_date] => 2015-07-10 [monday_s] => y [tuesday_s] => y [wednesday_s] => y [Thursday_s] => y [friday_s] => y [monday_bold] => y [tuesday_bold] => y [wednesday_bold] => y [Thursday_bold] => y [friday_bold] => y ) [8] => Array ( [schedule_id] => 4580 [schedule_track_id] => 50 [saved_name] => July 6-July 10 [time_stamp] => 2015-07-08 10:51:31 [employee] => Enrollment [monday] => 20 [tuesday] => 0 [wednesday] => 0 [Thursday] => 26 [friday] => 19 [class] => clubhouse [start_date] => 2015-07-06 [end_date] => 2015-07-10 [monday_s] => y [tuesday_s] => y [wednesday_s] => y [Thursday_s] => y [friday_s] => y [monday_bold] => y [tuesday_bold] => y [wednesday_bold] => y [Thursday_bold] => y [friday_bold] => y ) [9] => Array ( [schedule_id] => 4630 [schedule_track_id] => 50 [saved_name] => July 6-July 10 [time_stamp] => 2015-07-08 10:51:31 [employee] => Enrollment [monday] => 11 [tuesday] => 15 [wednesday] => 8 [Thursday] => 12 [friday] => 10 [class] => wobler [start_date] => 2015-07-06 [end_date] => 2015-07-10 [monday_s] => y [tuesday_s] => y [wednesday_s] => y [Thursday_s] => y [friday_s] => y [monday_bold] => y [tuesday_bold] => y [wednesday_bold] => y [Thursday_bold] => y [friday_bold] => y )

Ok the Quary is not failing from what i can tell it seems the display is whats failing. The database updates when you change the selection on the site and press update. The page for some reason is only displaying the first selection correctly the rest just say 0. Also noob question here do you me comment my code when you say use code tags.

This is a snippet from a site i built the code is suppose to take information from a database and display it then if the user changes it via a drop down menu and an update button it will change the information and again display it. The first display labeled infants works correctly but then nothing else does. It all updates the DB like it is suppose to but just wont display it. I have been banging my head for days on this any help would be great. FYI This all worked properly for about 8 months then just one day stopped. mysql_query("update schedule set ".$field_name." = '".$_POST['infant_ch']."' where schedule_track_id = '".$track_id."' and employee = 'Enrollment' and class='infants' "); mysql_query("update schedule set ".$field_name." = '".$_POST['wobbler_ch']."' where schedule_track_id = '".$track_id."' and employee = 'Enrollment' and class='wobler' "); mysql_query("update schedule set ".$field_name." = '".$_POST['orange_ch']."' where schedule_track_id = '".$track_id."' and employee = 'Enrollment' and class='orange' "); mysql_query("update schedule set ".$field_name." = '".$_POST['green_ch']."' where schedule_track_id = '".$track_id."' and employee = 'Enrollment' and class='green' "); mysql_query("update schedule set ".$field_name." = '".$_POST['red_ch']."' where schedule_track_id = '".$track_id."' and employee = 'Enrollment' and class='red' "); mysql_query("update schedule set ".$field_name." = '".$_POST['blue_ch']."' where schedule_track_id = '".$track_id."' and employee = 'Enrollment' and class='blue' "); mysql_query("update schedule set ".$field_name." = '".$_POST['purple_ch']."' where schedule_track_id = '".$track_id."' and employee = 'Enrollment' and class='purple' "); mysql_query("update schedule set ".$field_name." = '".$_POST['yellow_ch']."' where schedule_track_id = '".$track_id."' and employee = 'Enrollment' and class='yellow' "); mysql_query("update schedule set ".$field_name." = '".$_POST['silver_ch']."' where schedule_track_id = '".$track_id."' and employee = 'Enrollment' and class='silver' "); mysql_query("update schedule set ".$field_name." = '".$_POST['school_ch']."' where schedule_track_id = '".$track_id."' and employee = 'Enrollment' and class='clubhouse' "); $enroll_query = mysql_query("select * from schedule Where employee = 'Enrollment' and CURDATE() between start_date and end_date and schedule_track_id = '".$track_id."' "); while($data = mysql_fetch_assoc($enroll_query)) { $enroll_data[] = $data; } $new_field_name = $field_name.'_s'; // This is the display section// <td align="center" valign="top"><table width="90" border="1" cellpadding="0"> <tr> <td height="200" align="center" valign="middle"><label for="infant_ch"></label> <select name="infant_ch" id="infant_ch"> <?php if($enroll_data[0]['class'] == 'infants') { $data_field = $enroll_data[0][$field_name]; for($i=0;$i<=30;$i++) { ?> <option value="<?php echo $i; ?>" <?php if ($i==$data_field) { echo "selected";}?>><?php echo $i; ?></option> <?php } } else { for($i=0;$i<=30;$i++) { ?> <option value="<?php echo $i; ?>" ><?php echo $i; ?></option> <?php } } ?> </select></td> </tr> <tr> <td height="200" align="center"><label for="wobbler_ch"></label> <select name="wobbler_ch" id="wobbler_ch"> <?php if($enroll_data[1]['class'] == 'wobler') { $data_field = $enroll_data[1][$field_name]; for($i=0;$i<=30;$i++) { ?> <option value="<?php echo $i; ?>" <?php if ($i==$data_field) { echo "selected";}?>><?php echo $i; ?></option> <?php } } else { for($i=0;$i<=30;$i++) { ?> <option value="<?php echo $i; ?>" ><?php echo $i; ?></option> <?php } } ?> </select></td> </tr> <tr> <td height="200" align="center"><label for="orange_ch"></label> <select name="orange_ch" id="orange_ch"> <?php if($enroll_data[2]['class'] == 'orange') { $data_field = $enroll_data[2][$field_name]; for($i=0;$i<=30;$i++) { ?> <option value="<?php echo $i; ?>" <?php if ($i==$data_field) { echo "selected";}?>><?php echo $i; ?></option> <?php } } else { for($i=0;$i<=30;$i++) { ?> <option value="<?php echo $i; ?>" ><?php echo $i; ?></option> <?php } } ?> </select></td> </tr> <tr>