Simple SQL Query !

[Mad_T]

How do I right this correctly ??

$query = "SELECT * FROM downloads where expires >= time() order by date asc";

expires has a time stamp ie: 1268683141

Thanks 🙂

[dagon]

UNIX_TIMESTAMP()

11.6. Date and Time Functions

[Mad_T]

Thanks 🙂

but how do i write it correctly in my SQL query ?? :queasy:

[dagon]

$query = "SELECT * FROM downloads where expires >=UNIX_TIMESTAMP() order by date asc";

[Mad_T]

Thanks 🙂
sorted !

[Mad_T]

Hmmm..
doing this:

 $query = "SELECT * FROM downloads where expires >=UNIX_TIMESTAMP() order by date asc"; 

and this:

 $query = "SELECT * FROM downloads where expires < UNIX_TIMESTAMP() order by date asc"; 

show the same results...
WHY ?

expires = 1268683141

thanks 🙂