I changed my database from mysql 4.1.10 to mysql 5.0 and I encountered error in my calendar event page. The output of my calendar date was change instead of date it becomes “>” and also when I press the button to move to another month I can’t move to another month. I have no idea why it happened. Here is the old calendar code: PHP: <?php $dbCnx = @mysql_connect("localhost","", "") or die('Could not Connect to the database') mysql_select_db("mydb"); ?><html><script>function goLastMonth(month, year){if(month == 1){--year;month = 13;}document.location.href = '<?=$_SERVER['PHP_SELF'];?>?month='+(month-1)+'&year='+year;}function goNextMonth(month, year){if(month == 12){++year;month = 0;}document.location.href = '<?=$_SERVER['PHP_SELF'];?>?month='+(month+1)+'&year='+year;} function remChars(txtControl, txtCount, intMaxLength){if(txtControl.value.length > intMaxLength)txtControl.value = txtControl.value.substring(0, (intMaxLength-1));elsetxtCount.value = intMaxLength - txtControl.value.length;}function checkFilled() {var filled = 0var x = document.form1.calName.value;if (x.length > 0) {filled ++}var y = document.form1.calDesc.value;if (y.length > 0) {filled ++}if (filled == 2) {document.getElementById("Submit").disabled = false;}else {document.getElementById("Submit").disabled = true} // in case a field is filled then erased}</script><body><?php$day = (isset($_GET["day"])) ? $_GET['day'] : "";$month = (isset($_GET["month"])) ? $_GET['month'] : "";$year = (isset($_GET["year"])) ? $_GET['year'] : "";if(empty($day)){ $day = date("j"); }if(empty($month)){ $month = date("n"); }if(empty($year)){ $year = date("Y"); } $currentTimeStamp = strtotime("$year-$month-$day");$monthName = date("F", $currentTimeStamp);$numDays = date("t", $currentTimeStamp);$counter = 0;function hiLightEvt($eMonth,$eDay,$eYear){$todaysDate = date("n/j/Y");$dateToCompare = $eMonth . '/' . $eDay . '/' . $eYear;if($todaysDate == $dateToCompare){$aClass='class="today"';}else{$sql="select count(calDate) as eCount from calTbl where calDate = '" . $eMonth . '/' . $eDay . '/' . $eYear . "'";$result = mysql_query($sql);while($row= mysql_fetch_array($result)){if($row['eCount'] >=1){$aClass = 'class="event"';}elseif($row['eCount'] ==0){$aClass ='class="normal"';}}}return $aClass;}?><div id="Calendar_Event"><table width="350" cellpadding="0" cellspacing="0"><tr><td width="50" colspan="1"><input type="button" value=" < " onClick="goLastMonth(<?php echo $month . ", " . $year; ?>);"></td><td width="250" colspan="5"><span class="title" style="color:#FFFFFF"><?php echo $monthName . " " . $year; ?></span><br></td><td width="50" colspan="1" align="right"><input type="button" value=" > " onClick="goNextMonth(<?php echo $month . ", " . $year; ?>);"></td></tr> <tr><th>M</td><th>T</td><th>W</td><th>T</td><th>F</td><th>S</td><th>S</td></tr><tr><?phpfor($i = 1; $i < $numDays+1; $i++, $counter++){$dateToCompare = $month . '/' . $i . '/' . $year;$timeStamp = strtotime("$year-$month-$i");if($i == 1){$firstDay = date("N", $timeStamp);for($j = 1; $j < $firstDay; $j++, $counter++){echo "<td> </td>";} }if($counter % 7 == 0 ){?></tr><tr><?php}?><!--right here--><td width="50" <?=hiLightEvt($month,$i,$year);?>><a href="<?=$_SERVER['PHP_SELF'] . '?month='. $month . '&day=' . $i . '&year=' . $year;?>&v=1"><?=$i;?></a></td> <?php}?></table></div><div id="New_Event"><?phpif(isset($_GET['v'])){if(isset($_POST['Submit'])){$sql="insert into calTbl(calName,calDesc,calDate,calStamp) values('" . $_POST['calName'] ."','" . $_POST['calDesc'] . "','" . $_POST['calDate'] . "',now())";mysql_query($sql);}$sql="select calName,calDesc, DATE_FORMAT(calStamp, '%a %b %e %Y') as calStamp from calTbl where calDate = '" . $month . '/' . $day . '/' . $year . "'";$result = mysql_query($sql);$numRows = mysql_num_rows($result);if ($_SESSION['username']=="user1") { $check1=mysql_query("SELECT * FROM tbllogin WHERE Username='user1' AND Department='Staff' AND Permission='True'"); $check2 = mysql_fetch_array($check1); $username = $check2['Username']; $dep = $check2['Department']; $permiss = $check2['Permission']; if($username=="user1" && $dep=="Staff" && $permiss=="True"){ $_SESSION['isallowed'] = $check2['Permission']; ?> <a href="<?=$_SERVER['PHP_SELF'];?>?month=<?=$_GET['month'] . '&day=' . $_GET['day'] . '&year=' . $_GET['year'];?>&v=1&f=true">Add Even</a><a href="<?=$_SERVER['PHP_SELF'];?>?month=<?=$_GET['month'] . '&day=' . $_GET['day'] . '&year=' . $_GET['year'];?>&v=1&f=true">t</a><?php } }else { echo "You cannot Add New Event"; } ?></div><div id="Cal_Event"><?phpif(isset($_GET['f'])){include 'calform.php';}if($numRows == 0 ){echo '';}else{echo '<h3>Event Listed</h3>';while($row = mysql_fetch_array($result)){?><h5><?=$row['calName'];?></h5><?=$row['calDesc'];?><br/>Listed On: <?=$row['calStamp'];?><?php}}}?></div></body></html> On my new codes I only change the codes for the connection of database like the “host”, ”username”, ”password”, ”database name”, “table name”. Honestly, I have no idea why it happened after I change my database. Actually my tbluser was work so I connected in my database on my other webpage. Any help is highly appreciated. Thank you in advance.
