[SOLVED] return a specified range from database

[rkstevens]

My database table has two values:

PostDate that contains a timestamp when the record can be displayed

RemoveDate contains the timestamp when the record can no longer be displayed

 

The query:

$newsquery = "SELECT * FROM News WHERE ((PostDate < 'time()') AND (RemoveDate > 'time()')) ORDER BY PostDate DESC";

 

returns 0 records, when there are ones that are within the range.

I guess I have something wrong.

 

[Barand]

time() is PHP function. try

 

$newsquery = "SELECT * FROM News WHERE UNIX_TIMESTAMP() BETWEEN PostDate AND RemoveDate ORDER BY PostDate DESC";