Christoffer Kjølbæk I have a blog, therefore I am…

+----+-------------+
| id | username    |
+----+-------------+
|  1 | John Doe    | 
|  2 | Jane Doe    | 
|  3 | Richard Roe | 
+----+-------------+

+----+-------------+---------+--------------------------------------------------------------------------+
| id | in_reply_to | user_id | message                                                                  |
+----+-------------+---------+--------------------------------------------------------------------------+
|  1 |           0 |       2 | What is an optimal object-oriented program with an underlaying database? | 
|  2 |           0 |       1 | What does cohesion mean?                                                 | 
|  3 |           1 |       3 | Donno, check ostehamster.dk                                              | 
|  4 |           2 |       1 | Try http://en.wikipedia.org/wiki/Cohesion_%28computer_science%29         | 
+----+-------------+---------+--------------------------------------------------------------------------+

SELECT u.username, m.message
FROM messages m
LEFT JOIN user u ON u.id = m.user_id
WHERE m.id = 1 OR m.in_reply_to = 1 
ORDER BY m.id ASC;

+-------------+--------------------------------------------------------------------------+
| username    | message                                                                  |
+-------------+--------------------------------------------------------------------------+
| Jane Doe    | What is an optimal object-oriented program with an underlaying database? | 
| Richard Roe | Donno, check ostehamster.dk                                              | 
+-------------+--------------------------------------------------------------------------+

class User {
   int user_id;
   std::string username;
 
   public:
      User(int user_id);
      std::string get_username(void);
      int get_user_id(void);
 
   private:
      void load_user(int user_id);
}

class MessageBoard {
   int msg_id;
   std::string[] messages;
 
   public:
      MessageBoard(int msg_id);
      std_string print(void);
 
   private:
      void load_messageboard(int msg_id);
}

void print() {
   conn = mysql_init(NULL);
   if (!mysql_real_connect(conn, server, user, password, database, 0, NULL, 0)) {
      mysql_query(conn, "SELECT user_id, message FROM messages m WHERE m.id = 1 OR m.in_reply_to = 1  ORDER BY m.id ASC;")
 
      res = mysql_use_result(conn);
      while ((row = mysql_fetch_row(res)) != NULL) {
         User user = new User(atoi(row[1]));
         printf("User: %s, Message: %s\n", user.get_username(), row[2]);
      }
 
      mysql_free_result(res);
   }
 
   mysql_close(conn);
}

static User* get_cached_user(int user_id) {
   static std::vector< User* > cache;
 
   vector< User* > ::iterator it;
   /* Is the user chached? */
   for ( it=cache.begin() ; it < cache.end(); it++ ) {
      if( (*it).get_user_id() == user_id) {
         return (*it);
      }
   }
 
   /* Generate and cache user */
   cache.push_back(new User(user_id));
   return cache.back();
}

User*[] get_multiple_user(int[] ids)