How can i show rows after a certain time.

I have a var named loggedinat that holds a value like "2010-03-09 21:17:30"

I then want to select all rows from a table that have a timestamp newer than the above time..

( Ie, it shows newer rows than the time above )

SELECT * from test WHERE when >= '$logginat' ORDER BY id ASC limit 100;

Ima ssuming i need to do something else here to try and get mysql to understand the two values correctly?

Any ideas guys?

Thanks
G

Your query should work.
I just quickly tested it against a datetime field and a varchar field, and mysql does the casting from varchar to datetime automatically.

mysql> create table dtmTest( dtmReal datetime, strVal varchar(100));
Query OK, 0 rows affected (0.07 sec)

mysql> insert into dtmTest values ('2010-03-09 21:17:30','2010-03-09 21:17:30');
Query OK, 1 row affected (0.04 sec)

mysql> select * from dtmTest;
+---------------------+---------------------+
| dtmReal             | strVal              |
+---------------------+---------------------+
| 2010-03-09 21:17:30 | 2010-03-09 21:17:30 |
+---------------------+---------------------+
1 row in set (0.00 sec)

mysql> select 'found' from dtmTest where dtmReal < '2010-03-09 22:17:30';
+-------+
| found |
+-------+
| found |
+-------+
1 row in set (0.00 sec)

mysql> select 'found' from dtmTest where strVal < '2010-03-09 22:17:30';
+-------+
| found |
+-------+
| found |
+-------+
1 row in set (0.00 sec)

mysql> select 'found' from dtmTest where strVal < '2010-03-09 20:17:30';
Empty set (0.00 sec)

If your variable is a string you may need to convert it to a mysql dateformat.

http://dev.mysql.com/doc/refman/5.1/...on_str-to-date

Or not as the case maybe

Ah ha,
Thanks guys, Ive found teh issue, Looks like the "when" clause was a reserved word in sql.

( it loooks really strange when i readi t back to myself )
Ive changed the feildname and POW it works.

Thanks

Hummm, saying that.

I doesnt.

it either returns all rows or none.

Not "some" that are newer than the value in my $string.

Humm, looks like the issue is with a previous statement not putting the data into the session..
Odd ..

Ah well.
Thansk