xelA
Last Activity: Feb 11 '08, 08:57 AM
Joined: Jan 16 '08
Location:
-
Thanks for your concern. But why should I post my code again?... -
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.Leave a comment:
-
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($sq l);
}
function sechudle_course s()
{
//instantiate a course object
...Leave a comment:
-
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...Leave a comment:
-
Updating records
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=posit ion_courses($ti me_of_day);
$x=0;
$z=0;
$temp=0;
//getting the initial date
$date=set_date( 7,1,2008,true);... -
Updating Records in database
Here is my problem: I have created a table with five fields and populated it. Then I included another field . How can I update the the data in one field of each record?
No activity results to display
Leave a comment: