this is my select query i want to order by fetch record with two fields first and i want to order by with transType and after that with transDate
i am already given order by with this two fields but it is not working.
i know that there is something silly mistake but i can not find it
SELECT tranjectionId,date_format(transDate,'%d-%m-%Y') AS transDate,motiAmount,
transType,tranjection.partyId,item.itemName,gwt,loss,netwet,
party.partyName,melting,westage,finewet,rhodium,amount,bhav
FROM tranjection
LEFT JOIN party ON party.partyId = tranjection.partyId
LEFT JOIN item ON item.itemId = tranjection.itemId
WHERE tranjection.partyId = $_REQUEST['partyId']
AND transDate >= '$fromDate'
AND transDate <= '$toDate'
ORDER BY transType = 'I',
transDate
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…