PHP - Moved: Sql Order By Date Starting With 000-00-00

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=345631.0

This topic has been moved to JavaScript Help.

http://www.phpfreaks.com/forums/index.php?topic=347327.0

Greetings! I am really stock on this situation.

1. I have a variable $uc_order_created.
2. I have a code like this:

<b><?php echo t('Due Date:'); ?></b>
             </td>
                <td width="98%">
             <?php $duedate = mktime(0,0,0,date("m"),date("d")+30,date("Y"));
        echo "".date("F jS Y", $duedate);?>

3. How do I code if I want the result of $uc_order_created get displayed as Due Date using the code above? Or other modifications?
4. The situation now, the code is working when printing the invoice but its not based on $uc_order_created. So, every time I will edit the Order because of the change of items among others the Due Date will also update. All I want that when Order is edited the value of Due Date will still remain based on the $uc_order_created.

Thank you so much in advance for your help.

Hello,

I would like to order by date that contains day and month, like this: 14-3
Is this possible?

Quote

$sql = mysql_query("SELECT * FROM date WHERE online='1'");

I have 2 tables I have settup called Users_Messages and Users_Message_Replies inside each of these tables I have a row called DateSent, I'm trying to select from both of these tables and only display the latest Sent item by ID and order them all by date. I can get it to display the items correctly using the below code, but I can't get them to order correctly by the latest date in both of the Tables.
Code: [Select]
$page_query = mysql_query("
                         SELECT  MessageID, DateSent
                         FROM Users_Messages
                         WHERE ToID = '$user_ID'
                           
                           UNION
                         
                         SELECT  MessageID, DateSent
                         FROM Users_Messages
                         WHERE FromID = '$user_ID'

                         
                         ORDER BY DateSent DESC
                         ");
 
                      while ($replycheck = mysql_fetch_assoc($page_query)){

                          $message_idmainnew = $replycheck['MessageID'];
                          $date = $replycheck['DateSent'];

                          $sql2 = "SELECT  MainMessageID FROM Users_Message_Replies WHERE MainMessageID = '$message_idmainnew '";
                          $sql_result2 = mysql_query($sql2);
                          $replycheck2 = mysql_fetch_assoc($sql_result2);
                          $newreplyID = $replycheck2['MainMessageID'];
           
                          $sql4 = "SELECT MessageID FROM Users_Messages WHERE MessageID= '$message_idmainnew'";
                          $sql_result4 = mysql_query($sql4);
                          $messagecheck2 = mysql_fetch_assoc($sql_result4);
                          $newmessageID = $messagecheck2['MessageID'];

                          if ($newreplyID == NULL){
                          $sql2 = "SELECT * FROM Users_Messages WHERE MessageID= '$newmessageID' ORDER BY DateSent ASC";
                          $sql_result2 = mysql_query($sql2);
                          $message_row = mysql_fetch_assoc($sql_result2);
                         
                                $message_01 = $reply_row['Message'];
                      $date = $reply_row['DateSent'];
                      $date1 = strtotime($date);
                      $datemain = date('F j, Y, g:i a', $date1);
                     
                          }else{

                          $sql2 = "SELECT * FROM Users_Message_Replies WHERE MessageID= ' $newreplyID ' ORDER BY DateSent DESC";
                          $sql_result2 = mysql_query($sql2);
                          $reply_row = mysql_fetch_assoc($sql_result2);
 
                      $message_01 = $reply_row['Message'];

                           
                      $date = $reply_row['DateSent'];
                      $date1 = strtotime($date);
                      $datemain = date('F j, Y, g:i a', $date1);
                           }

                      {
Is there an easier way to do this? And how would I get the dates to line up, with a Join? Thanks.