PHP - Php/mysql Select From Order By Time??

My DB is holding time as "11:00 AM" "10:00 AM" ect...

Is there a way to convert these to time() after I have queried the DB for results?


<?php

connect();
$query = "SELECT * FROM party WHERE year(DOP) = '2011' order by PTIMES asc";
$qt=mysql_query($query);
echo mysql_error();
while($nt=mysql_fetch_array($qt)){

echo "
<tr height='30'> 
<td id='label'>".$nt['NOC']."</td>
<td id='labeloff'>".$nt['CFN']." ".$nt['CLN']."</td>
<td id='labeloff'>".$nt['type']."</td>
<td id='label'>".birthday($nt['DOB'])."</td>
<td id='label'>$DOP</td>
<td id='labeloff'>".$nt['PTIME']."</td>
<td id='labeloff'>".$nt['act1']."</td>
<td id='labeloff'>".$nt['act2']."</td>
<td id='label'>".$nt['pizza']."</td>
<td id='label'>".$nt['fc']."</td>
</tr>
";
}free($qt);

?>


Thank you.

I teach 6 different class groups, named "A" to "F", respectively.

I have a table in my database which stores lot of file names & file path. iam currently listing the files on the basis of its uploaded date (stored in databse) but  I want to list it on the basis of its file modification time.
How i can do it ??
my current sql statement is

Code: [Select]
$sql = mysql_query("SELECT * FROM `files` WHERE `cid` = '$types' ORDER BY `uploaded` DESC LIMIT $start,$limit");

anyone can help me ??

Hi ho, I am trying to assemble a table so that it shows article in order by id descending. The current one i am using is working but not displaying as i hoped, i need them aligned on the left and right, so id=1 align left, id=2 align right etc. Here's my current code

Code: [Select]
<table style='table-layout:fixed' align="center" cellpadding="2" cellspacing="0" colspan="" class="Main"><br>

<?
$select_paper=mysql_query("SELECT * FROM paper ORDER BY id DESC");
while($the=mysql_fetch_object($select_paper)){
?>
     <tr>
        <td class="subtableheader" width="25%"><?php echo "$the->title"; ?></td>
      </tr>

     <tr>
        <td class="profilerow"  width="100%"><?php echo "$the->news"; ?></td>
        </tr>
     <tr>
        <td class="subtableheader"  width="25%"><?php echo "Article By $the->by - $the->date"; ?></td>
        </tr>

Hi, I'm not necessarily looking for code examples for my problem, (they are welcome but its not my explicit goal). I'm looking more for advice on how to go about tackling the problem i have.

what i already have
Currently i have a search getting results from a MySQL database.
The results are ordered by one field that signifies their importance.
Many of these results have the same value in this one column, and i have a switch statement to distinguish different content/styles for the different values. (there are just over 10 different bands)

So the most important results are shown first and with a different style to the ones below it. (some bands have the same styling)

what i need
I would like to be able to randomize the results but only randomize the results within their specified bands.
e.g. lets say theres 100 results in band A and 100 in band B. I still want everything in band A to be listed above band B, but i would like to randomly change the order of the results in band A and band B, (in this case once a week). I need to save the order of this randomization (client/server side?) for a week, then run the script again to set a new order.


Now I would still class myself as an amateur php'er so at this stage i dont even know how i would go about separating the bands and randomizing their results independantly, let alone causing this functionality to run only once a week.



So can anyone suggest a way i might go about this? I'm pretty stuck right now.

Cheers

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.

Hi,

I'm inserting hours and minutes per user into a database where they have their own fields.
(userid, hours, mins)

I've a small issue when displaying the data.

When I run my query I sum the total hours and minutes per user which results in data such as the following

userid1 - 2  hours 15 mins
userid2 - 1 hour 100 mins

The query orders by hours and then mins desc

When I'm displaying the data (as I'm looping through the results array) I perform a calculation to convert the mins to hours so it now reads

userid1 - 2 hours 15 mins
userid2 - 2 hours 40 mins

so the webpage displays userid1 first when i want userid2 to be the first record displayed (Hours desc)

Can anyone recommend a solution to this ?
Will I need to create another table and update it as hours and minutes are being entered and display results from that table instead ?
Can I order the data after I carry out the mins to hours calculation ?

many thanks in advance for any suggestions....

tmfl

Hey guys, I am having trouble figuring this out. I currently have a database that automatically sorts itself by the id of the data. But, I am wanting the user to be able to change the sort order via a select box. I already have the select box programmed with the options, but I am not sure how to go about coding the options to change the sort order of the displayed data. What would the best way to go about programming this be?

Thank you very much ahead of time!!

Lets say I have this query:

$sql = mysql_query("SELECT * FROM Member ORDER BY posts DESC LIMIT 10");
while ($get = mysql_fetch_array($sql)){

$row .= $get['id'];
$posts .= $get['posts'];

echo "$row - $posts<br />";

}

Lets say I have two of rows, with posts fields of 84 and 803. When it displays it, it grabs the 84 row first, when I want the bigger number 803 first. Is there a way to fix this?

I'm currently trying to grab data from my database for my chatbox, which when displayed, displays in an ascending order, when I call it to descend, it shows the messages ONCE in descending order, then just repeats but in random order..

Code: [Select]
$sql = "SELECT * FROM `message` WHERE `chat_id` = 1 AND `message_id` > $last ORDER BY `message_id` DESC";
Database:
message_id | name
1                   RSX
2                   RSX
3                   RSX
4                   RSX

Code: [Select]
RSX: 4
RSX: 3
RSX: 2
RSX: 1
RSX: 4
RSX: 3
RSX: 2
RSX: 4
RSX: 3
RSX: 4

It is ordering it correctly, just repeats, I'm using Ajax, could that be the problem, or is it within the PHP code?

Edit:
I read it wrong, it displays as shown under "output".

When you make a mysql query the results are always returned with the first being the first entry in the database.  I was wondering if there is a way to make it so that the last entry is returned first and so on?  Thanks for any help. 

hello all.
I have a list of records, which each have a comment button, just like any forum does. when I click on the comment button it brings up the current record at the top, and a blank form, to which you enter in information.

When I submit this information, I want it to show up on the main page as a child of the parent record. I want it similar to the example I've shown below:
Code: [Select]
id name         dob           address              email                  username
1  john smith   10/11/1986    124 Peermont Drive   john.smith@yahoo.com   john smith1
  >>  2   Harry        15/12/1985     98 The Roundhay     harry@gmail.com        harry23
    >>>  3  jhk          08/11/1976     65 dfgdfg           gfdfg@ yahoo.com       jhk345
4  john smith   10/11/1986    124 Peermont Drive   john.smith@yahoo.com   john smith1
     >> 5 Harry        15/12/1985     98 The Roundhay     harry@gmail.com        harry23
        >>>> 6  jhk          08/11/1976     65 dfgdfg           gfdfg@ yahoo.com       jhk345

I've been stuck on this for hours, and I haven't got anywhere. Any ideas?

This topic has been moved to MySQL Help.

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

ok so i want to order by high to low on the field price but i don't know how to do this.

i can order low to high by using ORDER BY  `Price` ASC

but how can i order high to low?

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'");