HELP with query

[Anon]

$query = "SELECT (UNIX_TIMESTAMP(now())-UNIX_TIMESTAMP(OnlineStatus)) AS timediff FROM userStatus WHERE timediff < 28800 ";

I'll break the query down.

1. (UNIX_TIMESTAMP(now())-UNIX_TIMESTAMP(OnlineStatus))

The above finds the difference in seconds between the current time and the time in a field called OnlineStatus.

2. "AS timediff" gives an alias to the long statement.

3. The query does not retrieve any records when I add "WHERE timediff < 28800"

Is this because "timediff" is calculated within the same query?

If so, how else can the query be written? Thanks.

Richie.

[Anon]

$query = "SELECT UNIX_TIMESTAMP(now())-UNIX_TIMESTAMP(OnlineStatus) AS timediff FROM userStatus WHERE UNIX_TIMESTAMP(now())-UNIX_TIMESTAMP(OnlineStatus) < 28800 ";

[Anon]

Yes Las. Thanks so much.

Richie.