Advertisement
Guest User

Untitled

a guest
Feb 19th, 2017
79
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.34 KB | None | 0 0
  1. $events = Event::get()
  2. ->where('EventApproved', 'TRUE')
  3. ->filter(array(
  4. 'SearchFields:fulltext' => $keyword
  5. ))
  6. ->sort('EventDate', 'ASC');
  7.  
  8. // I essentially want to sort them using something like this
  9. ORDER BY abs(TIMEDIFF( NOW() , str_to_date(data_hora, '%d/%m/%Y %H:%i')))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement