hi...
i need help on this function...i want to sort data in a table that arrange the data according to the month,date and then year.
by using this code below, i am able to sort the data ascending according to date, but, the it follows the first number in the date2 column. for example, 1/2/2012,17/2/2012,2/1/2012.....i want it to be sorted like, 2/1/2012,1/2/2012,17/2/2012......
somebody please help me....this is urgent.....tq
i need help on this function...i want to sort data in a table that arrange the data according to the month,date and then year.
by using this code below, i am able to sort the data ascending according to date, but, the it follows the first number in the date2 column. for example, 1/2/2012,17/2/2012,2/1/2012.....i want it to be sorted like, 2/1/2012,1/2/2012,17/2/2012......
Code:
<?php
session_start();
include("dbconn.php");
if(isset($_SESSION ['username']))
{
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en">
<head>
<title>Web site</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta name="title" content="Web site" />
<meta name="description" content="Site description here" />
<meta name="keywords" content="keywords here" />
<meta name="language" content="en" />
<meta name="subject" content="Site subject here" />
<meta name="robots" content="All" />
<meta name="copyright" content="Your company" />
<meta name="abstract" content="Site description here" />
<meta name="MSSmartTagsPreventParsing" content="true" />
<link id="theme" rel="stylesheet" type="text/css" href="New folder/style.css" title="theme" />
<SCRIPT LANGUAGE="JavaScript">
function showDate()
{
var now = new Date();
var days = new Array('Ahad','Isnin','Selasa','Rabu','Khamis','Jumaat','Sabtu');
var months = new Array('Januari','Februari','Mac','April','Mei','Jun','Julai','Ogos','September','Oktober','November','Disember');
var date = ((now.getDate()<10) ? "0" : "")+ now.getDate();
function fourdigits(number)
{
return (number < 1000) ? number + 1900 : number;
}
tnow=new Date();
thour=now.getHours();
tmin=now.getMinutes();
tsec=now.getSeconds();
if (tmin<=9) { tmin="0"+tmin; }
if (tsec<=9) { tsec="0"+tsec; }
if (thour<10) { thour="0"+thour; }
today = days[now.getDay()] +"<br>"+ date + " " + months[now.getMonth()] + " "+ (fourdigits(now.getYear())) + " <br> " + thour + ":" + tmin +":"+ tsec;
document.getElementById("dateDiv").innerHTML = today;
}
setInterval("showDate()", 1000);
</script>
</head>
<body>
<form action="temp12.php" name="activityform" method="post">
<div id="wrapper">
<div id="bg">
<div id="header"><table width="80%" cellpadding="2" cellspacing="2" align="center">
<tr>
<td align="left"> </td>
</tr>
</table></div>
<div id="page">
<div id="container">
<!-- banner -->
<div id="banner"></div>
<!-- end banner -->
<!-- content -->
<div id="content">
<div id="left">
<div id="sidebar">
<ul class="vmenu">
<li>
<a href="temp6.php" shape="rect">Laman Utama</a>
<ul>
<li>
<a href="temp14.php" shape="rect">Visi</a>
<li>
<li>
<a href="temp14.php" shape="rect">Misi</a>
</li>
<li>
<a href="temp14.php" shape="rect">Piagam Pelanggan</a>
</li>
</ul>
</li>
<li>
<a href="temp10.php" shape="rect">Profil Saya</a>
</li>
<li>
<a href="temp8.php" shape="rect">Maklumat Staf</a>
</li>
<li>
<a href="temp9.php" shape="rect">Peta Lokasi</a>
</li>
<li>
<a href="temp11.php" shape="rect">Tugas Pegawai</a>
<ul >
<li>
<a href="temp12.php" shape="rect">Masukkan Data Baru</a>
</li>
<li>
<a href="temp13.php" shape="rect">Carian Data</a>
</li>
</ul>
</li>
</ul>
</div><br /><br />
<div id="sidebar">
<ul class="vmenu">
<li>
<br />
<table border="0" cellspacing="0" cellpadding="0"><tr><td align="center"><script type="text/javascript" src="http://www.worldtimeserver.com/clocks/embed.js"></script><script type="text/javascript" language="JavaScript">objMY=new Object;objMY.wtsclock="wtsclock001.swf";objMY.color="32CD32";objMY.wtsid="MY";objMY.width=130;objMY.height=130;objMY.wmode="transparent";showClock(objMY);</script></td></tr><tr><td align="center"><h2>Perlis</h2></td></tr></table>
</li>
<li><div id="dateDiv"></div></li>
</ul>
</div>
</div>
<div id="center">
<div id="welcome">
<h3>TUGAS HARIAN</h3>
<p><table width="600" border="1">
<!--DWLayoutTable-->
<tr>
<td height="23" colspan="2" valign="top" border:0px;> Nama : <?php echo $_SESSION['username']; ?></td>
</tr>
<tr>
<td width="829" height="23" valign="top"> Jawatan : </td>
</tr>
</table> </p>
<table border="2" width="600">
<tr>
<!--<td width="40" height="23" valign="top"> NO </td> -->
<td width="133" height="23" valign="top"> Tarikh</td>
<td width="523" valign="top"> Tugasan </td>
<td width="153" valign="top"> Catatan </td>
</tr>
<tr>
<!--<td>-->
<?php
$sqlGet= "SELECT * FROM staffactivity ORDER BY date2";
$queryGet = mysql_query($sqlGet) or die("Error: " . mysql_error());
while($rGet = mysql_fetch_assoc($queryGet))
{
//echo "<table border='0'>";
//echo "<tr>";
echo "<td class=/'fonttable/'>".$rGet['date2']."</td>";
echo "<td class='fonttable'>".$rGet['task2']."</td>";
echo "<td class='fonttable'>".$rGet['note2']."</td>";
echo "</tr>";
}
//echo "</table>";
?>
<!--</td>
</tr>-->
</table>
</div>
</div>
<div style="clear:both;height:40px"></div>
</div>
<!-- end content -->
</div>
<!-- end container -->
</div>
<div id="footerWrapper">
<div id="footer">
<p style="padding-top:1px;">
<a href="#" shape="rect">Home</a> |
<a href="#" shape="rect">Products</a> |
<a href="#" shape="rect">Services</a> |
<a href="#" shape="rect">News</a> |
<a href="#" shape="rect">About</a>
</p>
<p><table border="0" valign="middle" align="center">
<tr>
<td><font size="2" align="center">UNIT TEKNOLOGI MAKLUMAT, JABATAN KESIHATAN NEGERI PERLIS</font></td>
</tr>
<tr>
<td><font size="1" align="center">Disclaimer & Copyright | Technical support by : Unit Teknologi Maklumat JKNPs
Copyright @ 2011 - 2012 to Unit Teknologi Maklumat JKNPs.</font></td>
</tr>
</table></p>
</div>
</div>
</div>
</div>
</form>
</body>
</html>
<?php
}
else{
header("Location: temp1.php");
}
?>
<?php
/* close connection */
mysql_close($dbconn);
?>
Comment