$sql = "INSERT INTO chat (id,name,who,type,post,posted,room) VALUES(NULL,$from, $to, '$type', $message, $now, $location)";
          $this->oChat->exec($sql);
          $sql = "SELECT last_insert_rowid() as rid FROM chat";
          $res = $this->oChat->query($sql);
          if ($res) {
               $rowid = $res->fetch(PDO::FETCH_OBJ)->rid;
               $sql = "SELECT * FROM chat WHERE id = $rowid";
               $res = $this->oChat->query($sql)->fetch(PDO::FETCH_OBJ);
               var_dump($res);
          }