Hi there 
,
I have the following table
ID | Name
1 |
2 |
3 |
4 |
5 |
6 | book
7 | testing
8 | PERL
9 | CSS Mastery
10 | Cellphones
When I do a SELECT ID,Name FROM table ORDER BY Name; using a CGI Script, I get the following result:
1 |
6 | book
2 |
7 | testing
3 |
8 | PERL
4 |
9 | CSS Mastery
5 |
10 | Cellphones
Now if I use SQL Monitor, The expected results are returned:
ID | Name
1 |
2 |
3 |
4 |
5 |
6 | book
10 | Cellphones
9 | CSS Mastery
8 | PERL
7 | testing
Is there something I am missing here?
Thanks
Sacrifice is not about what you lose,
it is about what you gain in the process.
, I have the following table
Code:
ID | Name
1 |
2 |
3 |
4 |
5 |
6 | book
7 | testing
8 | PERL
9 | CSS Mastery
10 | Cellphones
When I do a SELECT ID,Name FROM table ORDER BY Name; using a CGI Script, I get the following result:
Code:
ID | Name 1 |
6 | book
2 |
7 | testing
3 |
8 | PERL
4 |
9 | CSS Mastery
5 |
10 | Cellphones
Now if I use SQL Monitor, The expected results are returned:
Code:
ID | Name
1 |
2 |
3 |
4 |
5 |
6 | book
10 | Cellphones
9 | CSS Mastery
8 | PERL
7 | testing
Is there something I am missing here?
Thanks
Sacrifice is not about what you lose,
it is about what you gain in the process.
MySQL Query ORDER BY giving weird results