Neverside

[mysql] select more or equal to??

Hi
what i want to do is select rows from my mysql where the tme column is more than or equal to $t.
I tried using ....
$t = time() - 520; if ne1 was wondering

Quote:

SELECT * FROM tablename WHERE tme >= $t ORDER tme DESC

but I get this error ....

Quote:

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '>= 1074039255 ORDER tme DESC' at line 1

Try looking at the documentation online at www.mysql.com

perhaps if you wrote your query like this

PHP:

<?php
SELECT * FROM tablename WHERE tme >= $t ORDER BY tme DESC 
?>

the clause must be "ORDER BY".

___________________