Jump to content


Photo

Display of records....


  • Please log in to reply
1 reply to this topic

#1 shan_cool

shan_cool
  • Members
  • PipPipPip
  • Advanced Member
  • 53 posts
  • LocationChennai,India

Posted 05 December 2005 - 05:10 AM

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..........


#2 ryanlwh

ryanlwh
  • Staff Alumni
  • Advanced Member
  • 511 posts

Posted 05 December 2005 - 06:30 PM

so Emp_Id is varchar?
Please use EDIT * 100...
Please use
or [php] * 1000...

PLEASE READ THE POSTED SOLUTIONS CAREFULLY * 1000000...




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users