How to sort a query

[Anon]

Hi... I want to sort the outcome of my query and use it according to dates of it was submitted... how can i do this... here is a sample of the mysql code query... thanks

$sqlQuery = "select * from motor where word regexp '$keyword'";

[jburfield]

Do you have a date field in the table?

If so, have you tried;
"select * from motor where word regexp '$keyword' order by DATEFIELD" ??

-- Jason