Get email of user

diff --git a/src/org/cacert/gigi/User.java b/src/org/cacert/gigi/User.java
index a7e6357667e24caa425c17a5c40e26fb5d0ffdf1..e21596638cc78648fb331718371d9365e7b6c750 100644 (file)
--- a/src/org/cacert/gigi/User.java
+++ b/src/org/cacert/gigi/User.java
@@ -20,12 +20,13 @@ public class User {
                this.id = id;
                try {
                        PreparedStatement ps = DatabaseConnection.getInstance().prepare(
-                                       "SELECT `fname`, `lname`, `dob` FROM `users` WHERE id=?");
+                                                       "SELECT `fname`, `lname`, `dob`, `email` FROM `users` WHERE id=?");
                        ps.setInt(1, id);
                        ResultSet rs = ps.executeQuery();
                        if (rs.next()) {
                                name = new Name(rs.getString(1), rs.getString(2));
                                dob = rs.getDate(3);
+                               email = rs.getString(4);
                        }
                        rs.close();
                } catch (SQLException e) {