$daydate=date("Y-m-d"); $tdate = explode("-", $daydate); $YR = $tdate[0]; $MH = $tdate[1]; $DY = $tdate[2]; $backdate=strftime("%Y-%m-%d", mktime(0,0,0,$MH,$DY-10,$YR)); //if ($sort) { $table_on=1; $linkurl="checklist"; # If phrase is only a contains search, add the % characters for the mysql query. if ($phrasetype == "contains") { $contains = "%$contains%"; } else { $contains = $contains; } if ($field == "") { $fieldquery = "and (date > '$backdate')"; $sort="date desc"; } if ($field != "") { $fieldquery = "and ($field like '%$contains%')"; } if ($s_owner != '') { $ownerquery = "and s_owner like '$s_owner'"; } $andquery = "$fieldquery ORDER by $sort"; $tablequery = "and (table_on = $table_on)"; PRINT "