random questions w/o repetition

[shinichi7]

hi newbie here and even in QT... i can't work on non-repeating question to display...please help

function riddles1() {
    var db = openDatabaseSync("riddleDB","1.0","riddle database", 10000)
    var rs
 
    db.transaction(function(tx) {
                     rs = tx.executeSql('SELECT * FROM riddle')
                   })
 
    //randomized riddle
    for ( var i = 1; i < (rs.rows.length - 1); i++) {
        var n = Math.floor(Math.random() * (rs.rows.length))
 
 }}

function riddles1() {
    var db = openDatabaseSync("riddleDB","1.0","riddle database", 10000)
    var rs

    db.transaction(function(tx) {
                     rs = tx.executeSql('SELECT * FROM riddle')
                   })

    //randomized riddle
    for ( var i = 1; i < (rs.rows.length - 1); i++) {
        var n = Math.floor(Math.random() * (rs.rows.length))
        
 }}

To copy to clipboard, switch view to plain text mode