Updating records

[xelA]

Thanks, it worked. Another problem:
Hey folks, where is the bug in this code? When updating the date field, it is updating all the records in the table with the same value (e.g. 2008-01-07) instead of incrementing the day by one in each record.
$schedule=position_courses($time_of_day);
$x=0;
$z=0;
$temp=0;
//getting the initial date
$date=set_date(7,1,2008,true);

foreach($schedule as $value)
{
$z++;
if($temp!=$value['day'])
{
$temp=$value['day'];
++$x;

if($x==5)
{
$x=0; //reseting the counter to 0
}
}
$day=$date['day'];
$month=$date['month'];
$year=$date['year'];
$day_name=$date['day_name'];
$full_date=$year.'-'.$month.'-'.$day;
if ($z!=1) $date=set_date($date['day'],$date['month'], $date['year'],false);

// Updating the date field in the table
$sql="UPDATE roomschedule SET date='$full_date'";

if (!mysql_query($sql,$con))
{
die('Error: ' . mysql_error());
}
Any help will be deeply appreciated. [e-mail]

[dlite922]

Be nice to the people who will help you, post your code using the [PHP ] and [/ PHP] around your code, to show us like this:


[PHP]
$schedule=position_courses($time_of_day);
$x=0;
$z=0;
$temp=0;
//getting the initial date
$date=set_date(7,1,2008,true);

foreach($schedule as $value)
{
$z++;

if($temp!=$value['day'])
{
$temp=$value['day'];

++$x;
if($x==5)
{
$x=0; //reseting the counter to 0
}
}

$day=$date['day'];
$month=$date['month'];
$year=$date['year'];
$day_name=$date['day_name'];
$full_date=$year.'-'.$month.'-'.$day;

if ($z!=1)
{
$date=set_date($date['day'],$date['month'], $date['year'],false);
}

// Updating the date field in the table
$sql="UPDATE roomschedule SET date='$full_date'";

if (!mysql_query($sql,$con))
{
die('Error: ' . mysql_error());
}
}// <--- bracket was missing?

[/PHP]

now let me read it to see if i can help.....

[dlite922]

In your Update you don't set which record to update, i.e. no WHERE clause.

UPDATE tablename SET fieldName = "fieldValue" WHERE $foo = 'bar';

MySQL by default sets every row to that value.

[xelA]

I did that. It is still updating all the records with same value (2008-01-07). No increment in date. What do I do? Please Help...

[Purple]

Hi xelA

Can you post your updated code and ideally don't forget the code tags.

Purple

[xelA]

Hi xelA

Can you post your updated code and ideally don't forget the code tags.

Purple

Here is my code.
(PHP)
<?php
require_once 'scheduler.php';
include 'generate_date.php';

draw_schedule();
function clear_existing_schedule()
{
//deleting existing contents to avoid duplication
$sql="DELETE FROM roomschedule";
mysql_query($sql);
}
function sechudle_courses()
{
//instantiate a course object
$course=new course();
$roomSchecdule=new roomSchedule();
//getDistinctCourses
$courses=$course->getDistinctCourses();

//deleting existing contents to avoid duplication
clear_existing_schedule();
$start=1;
foreach($courses as $value)
{
$numberOfStudents=$course->getNumberOfStudents($value);
$year_of_study=$course->getYearOfStudy($value);
if($year_of_study%2==1)$morning=1;else $morning=0;
$start=$roomSchecdule->updateRoomSchedule($value,$start,$morning,$number OfStudents);
}
}
function position_courses($time_of_day)
{
$roomSchecdule=new roomSchedule();
$course=new course();
$roomSchecdule->sheduleDays($time_of_day);
$days=$roomSchecdule->printDays($time_of_day);
$max=count($days);
$array_value=0;
$courses=$course->getDistinctCourses();
for($i=0;$i<$max;$i++)
{
$course_code=$days[$i][0];
$day_number=$days[$i][1];
if($day_number>$array_value)
{
$array_value++;
}
$numberOfStudents=$course->getNumberOfStudents($course_code);
$class_room=$roomSchecdule->get_classroom($course_code);
$schedule[$i]['day']=$array_value;
$schedule[$i]['course_code']=$course_code;
$schedule[$i]['room']= $class_room;
$schedule[$i]['number_of_students']=$numberOfStudents;
}
return $schedule;

}
function draw_schedule()
{
sechudle_courses();
for($i=0;$i<=1;$i++)
{
if($i==0)
{
$time_of_day='morning';
echo '<h4>MORNING SESSIONS (09:00HRS)</h4>';
}
else
{
$time_of_day='afternoon';
echo '<h4>AFTERNOON SESSIONS (14:00 HRS)</h4>';
}

$schedule=position_courses($time_of_day);
$x=0;
$z=0;
$temp=0; //a temporary variable for checking if the value of the date is greater or less
echo '<table border="1">';
echo '<tr><th>Day</th><th>Course Code</th><th>Venue</th><th>No of
Students</th><th>Date</th></tr>';

//get the starting date
$date=set_date(7,1,2008,true);
foreach($schedule as $value)
{
$z++;
if($temp!=$value['day'])
{
$temp=$value['day'];
++$x;
if($x==5)
{
$x=0; //reseting the counter to 0
}
}
$day=$date['day'];
$month=$date['month'];
$year=$date['year'];
$day_name=$date['day_name'];
$full_date=$year.'-'.$month.'-'.$day;
if ($z!=1) $date=set_date($date['day'],$date['month'], $date['year'],false);
$sql="UPDATE roomschedule SET date='$full_date' WHERE date='$full_date'";
mysql_query($sql);

echo'<tr><td>'.$day_name.'</td><td>'.$value['course_code'].'</td><td>'.$value['room'].'</td><td>'.$value['number_of_students'].'</td><td>'.$full_date.'</td></tr>';
}
echo '</table>';
}
}
?>

[dlite922]

Here is my code.
(PHP)
<?php
require_once 'scheduler.php';
include 'generate_date.php';

draw_schedule();
function clear_existing_schedule()
{
//deleting existing contents to avoid duplication
$sql="DELETE FROM roomschedule";
mysql_query($sql);
}
function sechudle_courses()
{
//instantiate a course object
$course=new course();
$roomSchecdule=new roomSchedule();
//getDistinctCourses
$courses=$course->getDistinctCourses();

//deleting existing contents to avoid duplication
clear_existing_schedule();
$start=1;
foreach($courses as $value)
{
$numberOfStudents=$course->getNumberOfStudents($value);
$year_of_study=$course->getYearOfStudy($value);
if($year_of_study%2==1)$morning=1;else $morning=0;
$start=$roomSchecdule->updateRoomSchedule($value,$start,$morning,$number OfStudents);
}
}
function position_courses($time_of_day)
{
$roomSchecdule=new roomSchedule();
$course=new course();
$roomSchecdule->sheduleDays($time_of_day);
$days=$roomSchecdule->printDays($time_of_day);
$max=count($days);
$array_value=0;
$courses=$course->getDistinctCourses();
for($i=0;$i<$max;$i++)
{
$course_code=$days[$i][0];
$day_number=$days[$i][1];
if($day_number>$array_value)
{
$array_value++;
}
$numberOfStudents=$course->getNumberOfStudents($course_code);
$class_room=$roomSchecdule->get_classroom($course_code);
$schedule[$i]['day']=$array_value;
$schedule[$i]['course_code']=$course_code;
$schedule[$i]['room']= $class_room;
$schedule[$i]['number_of_students']=$numberOfStudents;
}
return $schedule;

}
function draw_schedule()
{
sechudle_courses();
for($i=0;$i<=1;$i++)
{
if($i==0)
{
$time_of_day='morning';
echo '<h4>MORNING SESSIONS (09:00HRS)</h4>';
}
else
{
$time_of_day='afternoon';
echo '<h4>AFTERNOON SESSIONS (14:00 HRS)</h4>';
}

$schedule=position_courses($time_of_day);
$x=0;
$z=0;
$temp=0; //a temporary variable for checking if the value of the date is greater or less
echo '<table border="1">';
echo '<tr><th>Day</th><th>Course Code</th><th>Venue</th><th>No of
Students</th><th>Date</th></tr>';

//get the starting date
$date=set_date(7,1,2008,true);
foreach($schedule as $value)
{
$z++;
if($temp!=$value['day'])
{
$temp=$value['day'];
++$x;
if($x==5)
{
$x=0; //reseting the counter to 0
}
}
$day=$date['day'];
$month=$date['month'];
$year=$date['year'];
$day_name=$date['day_name'];
$full_date=$year.'-'.$month.'-'.$day;
if ($z!=1) $date=set_date($date['day'],$date['month'], $date['year'],false);
$sql="UPDATE roomschedule SET date='$full_date' WHERE date='$full_date'";
mysql_query($sql);

echo'<tr><td>'.$day_name.'</td><td>'.$value['course_code'].'</td><td>'.$value['room'].'</td><td>'.$value['number_of_students'].'</td><td>'.$full_date.'</td></tr>';
}
echo '</table>';
}
}
?>

before mysql_query($sql), write

die($sql);

paste this into mysql command line (if the error is not obvious by looking at it) and mysql will show you that query is executing the way it is.

[xelA]

Please don't be annoyed with me. I just need your help. After doing that, it is giving me the following error msg:

UPDATE roomschedule SET date='2008-01-07' WHERE date='2008-01-07'

If I echo full_date, it is showing me want I anticipate. The problem comes when entering the date in the table. It is failing to update the date field.

[Markus]

Please read the forum guidelines


And post the code again with the proper code tags.

[xelA]

Please read the forum guidelines


And post the code again with the proper code tags.

Thanks for your concern. But why should I post my code again?

[Markus]

Because people will just neglect to read your code if you haven't used code tags. Therefore, you not getting an answer.

Until a mod (few and far between) changed it, you'll have to repost it.

Or not.

Just remember to use proper code tags :)

[dlite922]

Oh for crying out loud:

[PHP]
<?php
require_once 'scheduler.php';
include 'generate_date.php';

draw_schedule();
function clear_existing_schedule()
{
//deleting existing contents to avoid duplication
$sql="DELETE FROM roomschedule";
mysql_query($sql);
}
function sechudle_courses()
{
//instantiate a course object
$course=new course();
$roomSchecdule=new roomSchedule();
//getDistinctCourses
$courses=$course->getDistinctCourses();

//deleting existing contents to avoid duplication
clear_existing_schedule();
$start=1;
foreach($courses as $value)
{
$numberOfStudents=$course->getNumberOfStudents($value);
$year_of_study=$course->getYearOfStudy($value);
if($year_of_study%2==1)$morning=1;else $morning=0;
$start=$roomSchecdule->updateRoomSchedule($value,$start,$morning,$number O fStudents);
}
}
function position_courses($time_of_day)
{
$roomSchecdule=new roomSchedule();
$course=new course();
$roomSchecdule->sheduleDays($time_of_day);
$days=$roomSchecdule->printDays($time_of_day);
$max=count($days);
$array_value=0;
$courses=$course->getDistinctCourses();
for($i=0;$i<$max;$i++)
{
$course_code=$days[$i][0];
$day_number=$days[$i][1];
if($day_number>$array_value)
{
$array_value++;
}
$numberOfStudents=$course->getNumberOfStudents($course_code);
$class_room=$roomSchecdule->get_classroom($course_code);
$schedule[$i]['day']=$array_value;
$schedule[$i]['course_code']=$course_code;
$schedule[$i]['room']= $class_room;
$schedule[$i]['number_of_students']=$numberOfStudents;
}
return $schedule;

}
function draw_schedule()
{
sechudle_courses();
for($i=0;$i<=1;$i++)
{
if($i==0)
{
$time_of_day='morning';
echo '<h4>MORNING SESSIONS (09:00HRS)</h4>';
}
else
{
$time_of_day='afternoon';
echo '<h4>AFTERNOON SESSIONS (14:00 HRS)</h4>';
}

$schedule=position_courses($time_of_day);
$x=0;
$z=0;
$temp=0; //a temporary variable for checking if the value of the date is greater or less
echo '<table border="1">';
echo '<tr><th>Day</th><th>Course Code</th><th>Venue</th><th>No of
Students</th><th>Date</th></tr>';

//get the starting date
$date=set_date(7,1,2008,true);
foreach($schedule as $value)
{
$z++;
if($temp!=$value['day'])
{
$temp=$value['day'];
++$x;
if($x==5)
{
$x=0; //reseting the counter to 0
}
}
$day=$date['day'];
$month=$date['month'];
$year=$date['year'];
$day_name=$date['day_name'];
$full_date=$year.'-'.$month.'-'.$day;
if ($z!=1) $date=set_date($date['day'],$date['month'], $date['year'],false);
$sql="UPDATE roomschedule SET date='$full_date' WHERE date='$full_date'";
mysql_query($sql);

echo'<tr><td>'.$day_name.'</td><td>'.$value['course_code'].'</td><td>'.$value['room'].'</td><td>'.$value['number_of_students'].'</td><td>'.$full_date.'</td></tr>';
}
echo '</table>';
}
}
?>


[/PHP]