Public feed #380336

Miscellany

public php v1 · immutable
Raw Edit
·published 2007-03-04 00:00 UTC
rendered paste body
$searchReqs = str_replace(" ", "%", $searchReqs['s'] );			$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 ORDER BY file_downloads DESC LIMIT $start, 15", mysql_escape_string($searchReqs));