|
From: Bradley M. <bra...@ac...> - 2002-06-07 19:56:15
|
On the filtering issue for projects, this works: SELECT *,(UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(date_modified)) as age,UNIX_TIMESTAMP(date_added) AS added_ts FROM tickets WHERE (1) AND (status != '7' AND status != '9') AND (creator = '1') AND ( project IN(3,4,5,1,2) OR (creator = 1) OR (owner = 1)) <bold>and project = 5 </bold>ORDER BY status DESC LIMIT 0,15 Now I just need to see if there's a place in the code to add that fairly painlessly? -- Bradley Miller |