[Resolved] Z to A ?

[russellbcv]

*format of xdate = 0412,0501,0502 etc.... (yymm)

How can I Z to A?

i.e "

0502
0501
0412

instead of...

0412
0501
0502

[laserlight]

Sort in reverse order then.

[russellbcv]

Yes, but how?

$sql = "select * from cdr where username = '" . $_SESSION['username'] . "'order by cdr.xdate";

How can sort in reverse order?

[laserlight]

ORDER BY column DESC

[russellbcv]

Which I have done but it's the wrong way?

The column description is "xdate"?

order by cdr.xdate

[laserlight]

Which I have done but it's the wrong way?

You havent.
You have simply specified that the result set should be sorted according to cdr.xdate, but whether to set ascending (ASC) or descending (DESC) is undefined, but usually defaults to ASC.

[russellbcv]

How would you include (ASC) or (DESC) ?

[laserlight]

The code is:

$sql = "SELECT * FROM cdr WHERE username='" . $_SESSION['username'] . "' ORDER BY cdr.xdate DESC";

I suggest that you actually read what people write, and try it out yourself.
I posted earlier:
ORDER BY column DESC

[russellbcv]

Thanks Laserlight

I didnt realise it was that simple!