0 order by web_sort_order_can, start_date ASC"; $result = @mysql_query($sql); //$result = 0; //User control of the backup files $sql_b = "Select active from reg_courses_backup WHERE backup_type = 'dates_can'"; $result_b = @mysql_query($sql_b); $row_b = @mysql_fetch_assoc($result_b); echo ''; ?> http://www.oxfordseminars.ca/dates.php Comprehensive ESL teacher training certificate courses held across Canada en-us http://cyber.law.harvard.edu/rss/rss.html OxfordSeminars Database jason.silver@oxfordseminars.ca webmaster@oxfordseminars.ca 120 \n"; echo "\t\t\t\n"; $anchor = str_replace(" ","_",$row['city']); echo "\t\t\thttp://www.oxfordseminars.ca/tesol-tesl-tefl-course.php#". $anchor ."\n"; echo "\t\t\t".$row['state_full']."\n"; echo "\t\t\t"; $variable1 = strip_tags($row['display1']); $variable2 = strip_tags($row['display2']); $variable1 = trim ($variable1); $variable2 = trim ($variable2); echo $variable1 . "<br />"; echo $variable2; /*********** Calculate Date Difference ******************/ $date = explode("-",$row['start_date']); $start = mktime(0,0,0,$date[1],$date[2],$date[0]); $curr = date('Y-m-d'); $curr = strtotime($curr); $diff = ($start-$curr)/86400; /*******************************************************/ if($diff > 0){ echo "<br /><a href='../register.php?course=".$row['course_ID']."'>Register for this course.</a>"; } //$row=mysql_fetch_assoc($result); echo "\n"; echo "\t\t\n"; } ?>