AS brand ON brand.cid = list.brandcodeORDER BY list.orderpriority DESC, list.date_addedDESC , list.cid DESC但是当你在我的php代码中(通过浏览器)运行它时,它会按字段[list.date_added]对数据进行排序。AS list LEFT JOIN brand
我有6个表1.产品p 2.属性a 3.产品和属性pa (ID,pID,aID ) 4.公司c 5. USer u 6.公司和用户cu (ID,cID,uID)SELECT p.ID, p.nameLEFT JOIN Product and Attribute pa ON pa.pID = p.ID LEFT JOIN Company and User cu ON cu.UiD = p.uID AND cu.cID
.* FROM $cashback_table where rg_store_id=$sanitized_store_id ORDER BY comm DESC ";
echo $sql5;commission+0) as comm , $cashback_table.* FROM $cashback_table where rg_store_id=$sanitized_store_id ORDER