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

Mesrop · 02.03.2006, 17: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 [email protected], heto 2 [email protected], heto 30 ... (PHP -um natcasesort -ova, bayc SQL -um cgidem)

chka ORDER -ic aveli lav dasavorelu hraman??

[ Xelgen ] · 02.03.2006, 20: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 · 02.03.2006, 21:28

anglereni het klni...

ay [email protected]
tveri hamar, chem kara int dnem..
VarChar a.
[email protected] text el ka... orinak
"2-ая улица" es kargi...

[ Xelgen ] · 02.03.2006, 21:53

Quote:

Originally Posted by Mesrop

tveri hamar, chem kara int dnem..
VarChar a.
[email protected] 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 _ · 05.03.2006, 17:54

It's so simple...

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

..or use MySQL CAST function!

02.03.2006, 17:34	#1
Mesrop полюбому йес эм... Join Date: 02 2005 Location: near the computer Age: 29 Posts: 3,243 Downloads: 3 Uploads: 0 Reputation: 129 \| 4	Сортировка результатов/ 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 [email protected], heto 2 [email protected], heto 30 ... (PHP -um natcasesort -ova, bayc SQL -um cgidem) chka ORDER -ic aveli lav dasavorelu hraman?? Share Share this post on Digg Del.icio.us Technorati Twitter __________________ Web Development - http://www.mesrop.info --- իմ լաստը \| իմ ֆկանտակտը \| իմ ադնակլասնիշկին \| իմ տունը \| ես.սեքսի.եմ --- www.imagger.com - Free Image Hosting System www.file.am

02.03.2006, 20:30	#2
[ Xelgen ] инсценирующи Join Date: 07 2002 Location: Fireplace of Ecotopia Age: 35 Posts: 4,327 Downloads: 22 Uploads: 0 Reputation: 193 \| 4	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) Share Share this post on Digg Del.icio.us Technorati Twitter __________________ ...ибо... Rgrdz. [ Кселджэн ]

02.03.2006, 21:28	#3
Mesrop полюбому йес эм... Join Date: 02 2005 Location: near the computer Age: 29 Posts: 3,243 Downloads: 3 Uploads: 0 Reputation: 129 \| 4	Re: Сортировка результатов/ MySQL anglereni het klni... ay [email protected] tveri hamar, chem kara int dnem.. VarChar a. [email protected] text el ka... orinak "2-ая улица" es kargi... Share Share this post on Digg Del.icio.us Technorati Twitter

05.03.2006, 17:54	#5
_ WOLF _ Волк, просто волк... Join Date: 07 2002 Location: /dev/null Age: 75 Posts: 250 Downloads: 0 Uploads: 0 Reputation: 0 \| 0	Re: Сортировка результатов/ MySQL It's so simple... SELECT * FROM `your_table_name` ORDER BY your_field_name+0; ..or use MySQL CAST function! Share Share this post on Digg Del.icio.us Technorati Twitter