Results 1 to 1 of 1
May 9, 2010, 20:54 #1
- Join Date
- Dec 2006
- 0 Post(s)
- 0 Thread(s)
how to sort array that extracted from database in this condition?
I'm trying to sort my search result with priority desc.
Thus, I get the data like this:
$result = mysql_query("SELECT id,status,priority,title from books
WHERE status='active' and MATCH(title)
AGAINST ('".$keyword."' IN BOOLEAN MODE)
order by priority desc, title asc limit $from,$limit")
May I know is it possible to do in the mysql query?