Using DESC for two fields 1

[kupe]

I want to group in descending order the records Sent and also Received when php summons info from the mysql db. When I code

... ORDER BY Received, Sent FROM tbl DESC

Received (or maybe Sent) is treated the wrong way. Be grateful for advice on the correct way.

 

[azzazzello]

What is *FROM tbl*? The syntax is ORDER BY <table>,<table> DESC.

 

[kupe]

Thanks, Azzazzello, there are two tables. But the fields Received and Sent are on tblOne. So would I say

ORDER BY tblOne.Sent, tblOne.Received, tblTwo DESC

? Doesn't look quite right.

 

[TonyGroves]

The syntax is:[tt]
ORDER BY field1 [DESC], field2 [DESC][/tt]

So you could say[tt]
ORDER BY sent DESC,received[/tt]
or[tt]
ORDER BY sent,received DESC[/tt]
and so on.

There is no need to specify the table names, unless the result set has two fields with the same name. In that case, you would qualify the field name as follows:[tt]
tablename.fieldname[t]]

 

[TonyGroves]

Sorry, slight formatting problem there. It should have been:


The syntax is:[tt]
ORDER BY field1 [DESC], field2 [DESC][/tt]

So you could say[tt]
ORDER BY sent DESC,received[/tt]
or[tt]
ORDER BY sent,received DESC[/tt]
and so on.

There is no need to specify the table names, unless the result set has two fields with the same name. In that case, you would qualify the field name as follows:[tt]
tablename.fieldname[/tt]

 

[kupe]

Great, Tony, much obliged. Good to hear from you.