Anyone see the problem?

[crabpot8]

Anyone see the problem with this? Basically I am trying to get this to work, so that I can modify it to say something similar to select *, ABS(DATEDIFF ... ) from ...

so that I can get 1) all the data and 2) the date diff in 1 query. Any help would be greatly appreciated

crabpot
[code=mysql]
SELECT timestamp, ABS(DATEDIFF(NO W(),timestamp) as dateDiff FROM `rmerror` ORDER BY `timestamp` DESC LIMIT 0, 100[/code]

[crabpot8]

Update:

answer was simple, I was missing a darned ')' lol
[code=mysql]
SELECT *, ABS(DATEDIFF(NO W(),timestamp)) as dateDiff FROM `rmerror` ORDER BY `timestamp` DESC LIMIT 0, 100[/code]

[Atli]

Glad you solved it.
Those sort of syntax errors can be a pain :)