let con = MySQL.Connection()
    let db_name = "mydb"

    do{
        // open a new connection
        try con.open("dbIPAddress", user: "dbusername", passwd: "dbpassword")

        // create a new database for tests, use exec since we don't expect any results


        // select the database
        try con.use(db_name)


        let password = passwordField.text;
        let email = emailField.text;
        let select_stmt = try con.prepare("SELECT userid FROM Users WHERE email=? and password =?")
        // insert 300 rows


        let res = try select_stmt.query([email! ,
            password!])

        //read all rows from the resultset
        let rows = try res.readRow()

        //updateMessageAndDismiss()
        print(String (rows!))

        if (rows!.count)==1{
            btnCLose()
        }else{
            print("invalid account")
        }

        // read rows 30 to 60
        try con.close()
    }
    catch (let e) {
        print(e)
    }


}