I tried to do date_format in the function requests...but doesn´t work !!
$database->setQuery("SELECT *, DATE_FORMAT(rent_from , '%d/%m/%Y'
FROM #__rem_houses AS a" .
" nLEFT JOIN #__rem_rent_request AS l" .
" nON l.fk_houseid = a.id" .
" nWHERE l.status = 0" .
" nORDER BY l.id DESC" .
" nLIMIT $pageNav->limitstart,$pageNav->limit;"
;
$rent_requests = $database->loadObjectList();
echo $database->getErrorMsg();
$total = $database->loadResult();
I NEED ANY HELP FOR THIS....!!!!!
Thanks
Beto