Сортировка результатов/ MySQL

Mesrop · Mar 2, 2006, 16:34

unem mi 320 toxani cucak, mysql -i mej Ruseren Windows-1251 -ov havaqac.
ORDER -ov vor talis em dasavori, motavora dasavorum, aysinqn arajin mi 3 tarerov a dasavorum.
isk tvernel dnuma skzbic 10 -@, heto 2 -@, heto 30 ... (PHP -um natcasesort -ova, bayc SQL -um cgidem)

chka ORDER -ic aveli lav dasavorelu hraman??

[ Xelgen ] · Mar 2, 2006, 19:30

Hm.. tver parunakogh dashty qo mot inci tipi e?
Dir tvain tip, integer kam en inch aveli shat e sazum qo depqum..
Et probley petq e vor verana.
Isk Anunneri het, chgitem, im mot anglereni het tenc xndir chi eghel, u yst tramabanutian cyrilicn el chpetq e vor tenc xndirner unena..

Che urish metodner chkan, ORDER BY ev GROUP BY (bayc verjiny papuk asac urish ban e anum)

Mesrop · Mar 2, 2006, 20:28

anglereni het klni...

ay ruseren@...
tveri hamar, chem kara int dnem..
VarChar a.
mej@ text el ka... orinak
"2-ая улица" es kargi...

[ Xelgen ] · Mar 2, 2006, 20:53

Quote:

Originally Posted by Mesrop

tveri hamar, chem kara int dnem..
VarChar a.
mej@ text el ka... orinak
"2-ая улица" es kargi...

Indz tvuma et depqum normal sirun lucum mian MySQLi ujerov chez karogh anel, kam tvyalnerid struktruan pordzi poxes. Chgitem te konkret qo mot inch xndir e.

_ WOLF _ · Mar 5, 2006, 16:54

It's so simple...

SELECT * FROM `your_table_name` ORDER BY your_field_name+0;

..or use MySQL CAST function!

Mar 2, 2006, 16:34	#1
Mesrop йес эм эли... Join Date: Feb 2005 Location: near the computer Posts: 3,203 Rep Power: 4 Reputation: 89	Сортировка результатов/ MySQL unem mi 320 toxani cucak, mysql -i mej Ruseren Windows-1251 -ov havaqac. ORDER -ov vor talis em dasavori, motavora dasavorum, aysinqn arajin mi 3 tarerov a dasavorum. isk tvernel dnuma skzbic 10 -@, heto 2 -@, heto 30 ... (PHP -um natcasesort -ova, bayc SQL -um cgidem) chka ORDER -ic aveli lav dasavorelu hraman?? __________________ իմ լաստը \| իմ ֆկանտակտը \| իմ տունը \| ես.սեքսի.եմ --- www.imagger.com - Free Image Hosting System www.armblogs.info, www.file.am, www.imageshare.am, www.softportal.am, www.marshrut.info

Mar 2, 2006, 19:30	#2
[ Xelgen ] инсценирующий жизнь Join Date: Jul 2002 Location: Fireplace of Ecotopia Posts: 4,165 Rep Power: 7 Reputation: 64	Re: Сортировка результатов/ MySQL Hm.. tver parunakogh dashty qo mot inci tipi e? Dir tvain tip, integer kam en inch aveli shat e sazum qo depqum.. Et probley petq e vor verana. Isk Anunneri het, chgitem, im mot anglereni het tenc xndir chi eghel, u yst tramabanutian cyrilicn el chpetq e vor tenc xndirner unena.. Che urish metodner chkan, ORDER BY ev GROUP BY (bayc verjiny papuk asac urish ban e anum) __________________ ...ибо... Rgrdz. [ Кселджэн ]

Mar 2, 2006, 20:28	#3
Mesrop йес эм эли... Join Date: Feb 2005 Location: near the computer Posts: 3,203 Rep Power: 4 Reputation: 89	Re: Сортировка результатов/ MySQL anglereni het klni... ay ruseren@... tveri hamar, chem kara int dnem.. VarChar a. mej@ text el ka... orinak "2-ая улица" es kargi... __________________ իմ լաստը \| իմ ֆկանտակտը \| իմ տունը \| ես.սեքսի.եմ --- www.imagger.com - Free Image Hosting System www.armblogs.info, www.file.am, www.imageshare.am, www.softportal.am, www.marshrut.info

Mar 5, 2006, 16:54	#5
_ WOLF _ Волк, просто волк... Join Date: Jul 2002 Location: /dev/null Posts: 250 Rep Power: 7 Reputation: 10	Re: Сортировка результатов/ MySQL It's so simple... SELECT * FROM `your_table_name` ORDER BY your_field_name+0; ..or use MySQL CAST function! __________________ 00000000h: 41 72 61 6D 20 4D 6B 68 69 74 61 72 79 61 6E;

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
MySql problem	poet	Web Development	10	Dec 18, 2005 09:00
MySQL Unicode problem with armenian	Aram Ghazanchyan	Web Development	6	May 12, 2005 11:11
MySQL Bot	Ektich	Software Security	0	Jan 28, 2005 08:28
Apache i MySQL + WIN XP = troubles ???	dude	Web Development	10	Sep 24, 2002 18:28