Need help with mysql Syntax

Discussion in 'Plugin Development' started by jwnordquist, Jun 13, 2012.

Thread Status:
Not open for further replies.
  1. Offline

    jwnordquist

    Hello, i'm sorry if i posted this in the wrong forum, feel free to move it if you wish. anyways, i am trying to sort a mysql database before it displaying.

    what i'm trying to do: order it by a calculation of 3 rows, row1/row2 * (.3 * row3)

    what i have tried:
    ORDER BY up / down *(.3 * players) DESC");

    If anyone could help me out with this, your help will be greatly appreciated!

    Thanks,
    ~Jake
     
    jwnordquist, Jun 13, 2012
    #1
  2. Offline

    Forge_User_58953186

    Are you sure you can use calculations inside the order by?
     
    Forge_User_58953186, Jun 13, 2012
    #2
  3. Offline

    Brant Wladichuk

    I dont believe you can make calculations like that.

    What are you trying to achieve? theres probably another way
     
    Brant Wladichuk, Jun 13, 2012
    #3
Thread Status:
Not open for further replies.

Share This Page