how to query search at the time getdate()?

[nanat]

what is the right syntax of this statement?

SELECT t1.*,t2.* FROM files t1 inner join users t2 on t1.userid = t2.userID where t1.DocTitle like '%".$kword."%' where t1.effictivedate > getdate()

i want my date to expire when its due date at the same time i can search..

what is the right syntax for this?

tnx guys :D

[nanat]

i get it hehehe...

$result = mssql_query("SELECT t1.*,t2.* FROM files
t1 inner join users t2 on t1.userid = t2.userID
where t1.DocTitle like '%".$kword."%' and t1.effictivedate > getdate()");