Jump to content

Problems With Order By


yosi501r
 Share

Recommended Posts

Hi everybody!These days I make a customers management system as a local site.I made a table to view all the registered customers ordered by their names using this command:SELECT FROM CUSTOMERS NAME, ID ORDER BY NAME;Name field is VARCHAR type!I use PHP:mysql_fetch_assoc();But I have two problems:1. Hebrew names are not correctly ordered( I see the 3rd letter first, the 1st letter after, and the last letter in the end).2. Name in Hebrew and English are combined, I see some names in EN and after some in HEB, and it continues.I really need your help, I asked others and they have no idea how to fix the problem.Thanks for every helper!

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...