Public feed #380344

Someone

public php v1 · immutable
Raw Edit
·published 2007-03-04 00:09 UTC
rendered paste body
$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) );