how to make mysql query with order by last answered question

how to make something like this, how in this forum, whos question was last answerwed, that will be first showed in forum

thanks

Hi,

can you be a bit more specific in your question ?

Hervé.

i only want make this

mysql.query(select question from questions order by 'question to which have answered last time' );

this is how in this forum, if question is answered then this question is in top of questions///

Well, it's a sort (SORT BY) based on the TIMESTAMP of the message; the rest of the query depend
of the structure of the DB.

here is what u must do :

$query = mysql_query ("SELECT FROM table order by date");
or
$query = mysql_query ("SELECT FROM tablename ORDER BY date DESC");

NOTE this assumes that you have a "date" field witch stores date
if you don't , run this script line:

$date_field = mysql_query ("ALTER TABLE tablename ADD data datetime");