| dcrystalj 10:13:10 | 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 |
| smo1234 10-16-2010 | 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 |