Qqlite + HTML5 put results into variables

Question

And I’m doing a query in a Sqlite database and wanted the result to be stored in a javascript variable so I can work with these results in the rest of the code.

I’m doing like this:

db.transaction(function(tx) {
var ide = 1;

tx.executeSql('SELECT * FROM tab_users', [ide], function (tx, results) {
var len = results.rows.length, i;

     for (i = 0; i < len; i++) {
       var_name = results.rows.item(i).name;
       var_country = results.rows.item(i).country;
     }

});
});
alert ("Name is " + var_name + " and country is " + var_country);

But this code does not work.. only if I put the alert within the loop that way:

for (i = 0; i < len; i++) {
   var_name = results.rows.item(i).name;
   var_country = results.rows.item(i).country;

   alert ("Name is " + var_name + " and country is " + var_country);

}

I need these variables to use at the end of my html code Does anyone have any suggestions on how I’m going to do this?