sort date in sql by DDMMYYYY

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......

Expand|Select|Wrap|Line Numbers

 <?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">&nbsp;</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;>&nbsp;&nbsp;&nbsp;Nama &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <?php echo $_SESSION['username']; ?></td> 

  </tr>

    <tr>

      <td width="829" height="23" valign="top">&nbsp;&nbsp;&nbsp;Jawatan &nbsp;&nbsp; :&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td> 

</tr>

</table>&nbsp;</p>  

  <table border="2" width="600">

    <tr> 

     <!--<td width="40" height="23" valign="top">&nbsp;&nbsp;&nbsp;NO </td> -->

     <td width="133" height="23" valign="top">&nbsp;&nbsp;&nbsp;Tarikh</td>

     <td width="523" valign="top">&nbsp;&nbsp;&nbsp;Tugasan </td> 

     <td width="153" valign="top">&nbsp;&nbsp;&nbsp;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);

?>

somebody please help me....this is urgent.....tq

Feb 22 '12 #1

Subscribe Post Reply

2216

Dormilich

8,658

Expert Mod 8TB

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......

let me guess, your date column is not in a MySQL DATE format?

Feb 22 '12 #2

ammyra91

the date is not in a MySQL format. i download it from http://www.javascriptkit.com/script/...calendar.shtml...

Feb 23 '12 #3

by: Sandy | last post by:

I am not sure how this even changed but... Until just recently when I went into any database and listed stored procedures I could list by the date which was in the format: mm/dd/yyyy. This...

Microsoft SQL Server

Sort Date Field String

by: andrew | last post by:

Hi: I am already using TreeMap to massage records in my export file such that each record has a unique key combination ( LastName + FirstName + Member Key) . Thus I am sorting the records by...

Java

Sort a month

by: Katarina | last post by:

Hello all, I need help for sort date("Table"). How can I sort a month, then year? Thanks in advance, Catherine

Microsoft Access / VBA

DataGrid Sort Expression for a date in format 'dd mmm yy'

by: yer darn tootin | last post by:

Does anyone know the sort expression for a column that's data has been returned in the format, eg '07 Jul 05'?? The sort expression {..:"dd mmm yy"} doesn't work ( if the column was returned as...

ASP.NET

How to order by date desc... onload ...

by: aRTx | last post by:

<? /* Directory Listing Script - Version 2 ==================================== Script Author: Artani <artan_p@msn.com>. www.artxcenter.com REQUIREMENTS ============ This script requires...

PHP

How to sort date regardless of month and year in query or report for Access 2000?

by: HowHow | last post by:

I need to sort the "DateOfBirth" by the day (dd) regarless of month (mm)and year (yyyy). I have a query called q_DC_Client, in criteria, I am using this code below: Like "*" & "/" & !! & "/" & "*"...

Microsoft Access / VBA

VB.net dataview sort not working

by: jwardgolf | last post by:

I have tried to use the sort but I don't see the changes in my dataview.... I have printed the first row and column after I have sorted it... No change on the date.... ...

.NET Framework

Sort DataTable -C#

by: Bimal Kothari | last post by:

private DataTable SortDataTable(DataTable GetDataTable, string sort) { DataTable _NewDataTable = GetDataTable.Clone(); int rowCount = GetDataTable.Rows.Count; DataRow foundRows =...

C# / C Sharp

How to sort files by Date with this Script?

by: aRTx | last post by:

I have try a couple of time but does not work for me My files everytime are sortet by NAME. I want to Sort my files by Date-desc. Can anyone help me to do it? The Script <? /* ORIGJINALI

PHP

Sorting files by date

by: lion cave | last post by:

Hello, I would like to ask on how to sort files by date modified and displaying the top 20 latest date. Heres, my sample function that would return the files to be displayed function...

PHP

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

sort date in sql by DDMMYYYY

Similar topics