Jump to content

Problems With Order By


yosi501r

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...