Public feed
#380344
$searchReqs = explode(" ", $searchReqs['s'] );$where = array();foreach($searchReqs AS $word) { $word = mysql_escape_string($word); $where[] = "(file_disp LIKE( '%$word%'))";}$additionalWhere = '('.implode(' OR ', $where).')'; $sql = sprintf("SELECT fileid,file_downloads,file_disp,file_cat,file_desc,cu.username,cat_name,cat_disp,TIMESTAMPDIFF(DAY, file_add_date, NOW()) AS file_days, TIMESTAMPDIFF(HOUR, file_add_date, NOW()) AS file_hours,TIMESTAMPDIFF(MINUTE, file_add_date, NOW()) AS file_minutes FROM com_files cf LEFT JOIN com_users cu ON cf.file_owner=cu.userid LEFT JOIN com_categories ON file_cat=catid WHERE file_disp LIKE '%s' AND file_active = 1 AND $additionalWhere ORDER BY file_downloads DESC LIMIT $start, 15", mysql_escape_string($searchReqs) );