Jump to content


Photo

ORDER BY issues with UniServer

sql

  • Please log in to reply
No replies to this topic

#1 snecia

snecia

    Newbie

  • Member
  • Pip
  • 4 posts
  • Main OS: Windows 8

Posted 26 October 2013 - 02:41 PM

I just switched from XAMPP to uniform server today. I'm running the same scripts, without any modification.

 

This:

$sql = "SELECT * FROM rooms WHERE date = '$year/$month/$day' ORDER BY roomNb";

works fine. Under XAMPP it returned the room numbers ordered from 1 to X.

 

Under uniform server I got:

9
10
11
12
14
8
7
6
5
4
3
2
1

Any ideas?

 

Thanks for your time,

 

Alex







Also tagged with one or more of these keywords: sql

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users