shan_cool Posted December 5, 2005 Share Posted December 5, 2005 Hi all, I need to dispaly a set of records in ascending order.. I hav given the query as: Select * From Emp_Det where Emp_Id like '$Emp_Id%' and Emp_Status <> 'R' order by Emp_Id ASC It displays: EmployeeId Name 1 Ranga 10 Sajan C K 101 Sridevi 112 Niraj 198 Florence Lavanya 199 M.Subbarao 2 N N Subramanian 20 Rosario but i neeed to display it as: EmployeeId Name 1 Ranga 2 N N Subramanian 10 Sajan C K 20 Rosario 101 Sridevi 112 Niraj 198 Florence Lavanya 199 M.Subbarao plz help me out to change it.... shan, chennai, India.......... Link to comment https://forums.phpfreaks.com/topic/2982-display-of-records/ Share on other sites More sharing options...
ryanlwh Posted December 5, 2005 Share Posted December 5, 2005 so Emp_Id is varchar? Link to comment https://forums.phpfreaks.com/topic/2982-display-of-records/#findComment-10030 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.