if(result.rows.length == 0)
                output = "<em>There are no records to display!</em>";
            else
            {
                output += "<table border='1' width='80%'>";

                var noOfRows = result.rows.length;

                for(var i = 0, row = null; i < noOfRows; i++)
                {
                    //assign row to a variable
                    row = result.rows.item(i);
                    //process each record
                    output += "<tr>";


                    output += "<td>" + row['fldName'] + ""
                    output += " " + row['fldNoOfPeople'] + ""
                    output += " " + row['fldType'] + ""
                    output += " " + row['fldLevel'] + ""
                    output += " " + row['fldCamera'] + "</td>"
                    output += "</tr>";

                }
                output += "</table>";
            }
            $("#results").html(output);