August 29, 2008 05:55pm pdt

1. hielo 737,247
2. hernst42 339,932
3. angelIII 295,760
4. logudotcom 175,643
5. Ray_Pas... 146,471
6. routinet 146,197
7. Roonaan 123,118
8. glcummins 106,477
9. RQuadling 104,446
10. nplib 102,478
11. yodercm 88,064
12. bportlock 81,562
13. rowejd 81,043
14. dr_dedo 80,410
15. Xyptilon2 77,792
16. fibo 76,001
17. gamebits 52,244
18. ali_kayahan 47,199
19. Michael701 47,100
20. steelseth12 45,854
21. jason1178 44,225
22. Tchuki 42,712
23. ee_rlee 40,914
24. virmaior 40,885
25. cedlinx 40,325

1. hernst42 895,805
2. angelIII 880,927
3. hielo 754,172
4. ldbkutty 688,003
5. Roonaan 651,058
6. wasifg 504,829
7. RQuadling 487,059
8. snoyes_jw 401,445
9. glcummins 377,790
10. gamebits 308,148
11. steelseth12 303,129
12. i_m_aa... 296,907
13. yodercm 280,300
14. TeRReF 263,550
15. routinet 246,046
16. Diablo84 239,472
17. nizsmo 230,942
18. dr_dedo 214,525
19. akshah123 211,024
20. Raynard7 209,268
21. WoodyRo... 207,207
22. logudotcom 182,611
23. nplib 172,702
24. AlanJDM 163,732
25. Tomeeboy 161,416

07.06.2008 at 11:50AM PDT, ID: 23541919

	[x] Attachment Details

Display problem of mysql sort

Asked by pertrai1 in PHP and Databases, PHP Scripting Language

Tags: php mysql

Hi, I have a database set up for a FAQ. For each question I have a order where each question is giving a numerical placing with default being 0. I had 9 records and they sorted fine ASC. When I added the 10th record it showed up between 1 and 2. How can I have it so that the records will show up correctly in order? I query the database simply with $query_faq = "SELECT * FROM faq ORDER BY `order` ASC";

Thank you in advance for help.

RobStart Free Trial

Keywords: Display problem of mysql sort

	Title
1	Dynamic Sort By Query
2	struggling with mysql query
3	MySQL Query Sort
4	Sorting values based on MySQL record…
5	how to do sorting use php and mysql
6	Need to search ASC/DESC MySQL Fi…

Loading Advertisement...

20080716-EE-VQP-32 / EE_QW_2_20070628

Display problem of mysql sort

Asked by pertrai1 in PHP and Databases, PHP Scripting Language

Tags: php mysql

About this solution