need help in order by clause

[doforumda]

i want to select data from db order by date column and display the latest post first

 

$query = "SELECT * FROM jobs_uni limit $start, $per_page";
//echo $query;
$result = mysql_query($query);

 

how to do this?

[Philip]

ORDER BY date DESC?

[doforumda]

i already use that this way

$query = "SELECT * FROM jobs_uni limit $start, $per_page ORDER BY date DESC";

 

and

 

$query = "SELECT * FROM jobs_uni  ORDER BY date DESC limit $start, $per_page";

 

both are not working

[cags]

$query = "SELECT * FROM jobs_uni  ORDER BY date DESC LIMIT $start, $per_page";

 

Looks correct. But you might wish to put back ticks around the column name of date as I think it may be a keyword (`date`).

[Philip]

@OP: What "isn't working"? Do you get an error? If so, what is it?

 

@cags: Date is not a reserved keyword that requires backticks. See here for the full list.

MySQL allows some keywords to be used as unquoted identifiers because many people previously used them. ACTION, BIT, DATE, ENUM, NO, TEXT, TIME, TIMESTAMP

[cags]

Ahh I wasn't certain, which is why I said 'I think', thanks for the link though, that may come in helpfull.

[fenway]

@OP: What "isn't working"? Do you get an error? If so, what is it?

 

@cags: Date is not a reserved keyword that requires backticks. See here for the full list.

MySQL allows some keywords to be used as unquoted identifiers because many people previously used them. ACTION, BIT, DATE, ENUM, NO, TEXT, TIME, TIMESTAMP

That doesn't mean they aren't keywords -- and they are poor choices for column names.