$sql = "SELECT *
FROM listing
WHERE (MATCH(dir_heading)
AGAINST ('$wtfld' IN BOOLEAN MODE)) AND busns_suburb LIKE '%".$whrfld."%' " ;
I want to add ORDER BY to this code but I can't implement it correctly.
Asked
Active
Viewed 34 times
-2
Sloan Thrasher
- 4,953
- 3
- 22
- 40
Preshy Odili
- 1
- 2
-
Please share your table schema and data. – Sookie Singh Aug 04 '18 at 10:56
-
my table column is S/N, dir_heading, busns_name, busns_loc, busns suburb. and i want the search result to display in ORDER BY busns_name – Preshy Odili Aug 04 '18 at 11:00
-
Add the order by after your WHERE clause: ```ORDER BY busns_name``` – Sloan Thrasher Aug 04 '18 at 11:34
1 Answers
0
As mentioned in my comment above, add the order by following the where clause:
$sql = "SELECT *
FROM listing
WHERE (MATCH(dir_heading)
AGAINST ('$wtfld' IN BOOLEAN MODE)) AND busns_suburb LIKE '%".$whrfld."%'
ORDER BY busns_name;" ;
Sloan Thrasher
- 4,953
- 3
- 22
- 40