| 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 |