Forum Sign UP Login Contact Us
HOME : Forum : SQL and Database : Post New Topic
competition system
dcrystalj
10:13:10 16:05
Hi
I got a problem with competition system

table i've made is position and times
so the order i want to get is

person x first 2 times and second 1 time
person y first 2 times
persin z second 5 times

problem is that if do sql querry order by position, times DESC i get order like

person y first 2 times
person x first 2 times and second 1 time
persin z second 5 times
subhendu
10:16:10 07:33
If your position field is not numeric then it will be displayed in alphabetical order. That will not solve your problem. So store the position as 1, 2, 3 like this.

Read Order by here
Please Login to post your reply or start a new topic
Privacy Policy | Disclaimer
©2000 - 2014 plus2net.com All rights reserved worldwide