[RESOLVED] [MYSql] ORDER by from 2 column value?

[hayato1]

i doesn't seems to get right............

i have 2 column dateline from vbulletin db editlog & post
i wanted "ORDER BY" displaying dateline depending which dateline is newer "mixing togther accordingly"

if i wrote this ORDER BY editlog.dateline, post.dateline
which is not what i wanted, as result returns new post's dateline all the way to bottom.... while recent post edit's dateline by the top

is there any way to get result returns
like sorting both column as one column

~thanks

[tomhath]

I suppose a CASE statement would work, something like this:

ORDER BY CASE WHEN editlog.dateline < post.dateline 
                THEN editlog.dateline 
                ELSE post.dateline
                END 

[hayato1]

edited....
it works!!!
after i changed the side

editlog.dateline > post.dateline

original msg:
hi, tomhath, thanks for reply but doesn't seems to work as wanted

or maybe i get the point wrong, which makes you misunderstood what i want,
it is like treating both column as index
and sort by which ever is greater/smaller

example.value: post.dateline=1,3,5,7
example.value: editlog.dateline=2,4,6,8

output.value sorted:
post.dateline 1
editlog.dateline 2
post.dateline 3
editlog.dateline 4
post.dateline 5
editlog.dateline 6
post.dateline 7
editlog.dateline 8