Sort by...

[coolphpdude]

Hey again,

 

If im doing a message board type system and i want to arrange messages by date and time how do i do it? at the moment im just selecting all records from my message table where user id=xx then outputting the messages using a while loop

[ansarka]

  give order by date

[coolphpdude]

$message_result = mysql_query("SELECT * FROM usermessages WHERE user_id='$user_session_id' ORDER BY date AND time", $db); ???

 

[Xil3]

$message_result = mysql_query("SELECT * FROM usermessages WHERE user_id='$user_session_id' ORDER BY date AND time", $db); ???

 

 

Change the "AND" between the date and time to a comma (,) as per below:

 

$message_result = mysql_query("SELECT * FROM usermessages WHERE user_id='$user_session_id' ORDER BY date, time", $db);

[Xil3]

You can also add DESC to reverse the order as per below:

 

$message_result = mysql_query("SELECT * FROM usermessages WHERE user_id='$user_session_id' ORDER BY date DESC, time DESC", $db);

[coolphpdude]

Thanks thats great