doforumda
10-19-2009, 07:54 AM
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?
i already use 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
$query = "SELECT * FROM jobs_uni limit $start, $per_page";
//echo $query;
$result = mysql_query($query);
how to do this?
i already use 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