toddoli

Forum Replies Created

Viewing 1 replies (of 1 total)
  • toddoli

    (@toddoli)

    Hi all,

    I’m using v2.0 free version of the plugin and was just facing the same problem, perhaps with another actual behavior. Actually my database table wp_hmp_playlist is getting filled song by song with an incremental ID, but if I performed a SELECT * FROM wp_hmp_playlist, the result was not ordered by ID…strange.

    So my solution was to change line 426 from the plugin’s “add_playlist.php” file located in the “playlist” folder of the plugin’s root folder:
    From
    $sql = "SELECT * FROM $table";
    To
    $sql = "SELECT * FROM $table ORDER BY 'id' ASC ";

    ^
    |– That’s for the playlist’s settings page but you’ll have to do the same for the playlist’s display so this time it’s the “index.php” file located in the plugin’s root folder and this time it’s line 108 so again:
    From
    $sql = "SELECT * FROM $table";
    To
    $sql = "SELECT * FROM $table ORDER BY 'id' ASC ";

    Hoping it’ll help you…

Viewing 1 replies (of 1 total)