There are 5 names for 1 player but the message seems to be one Sample: PHP: SQL Table p1 p2Rexius - blabla1Rexius - blabla2Rexius - blabla3player send messages > blabla1, I want messages > blabla1, blabla2, blabla3 PHP: $msg = null; foreach($this->getPlayer($player) as $table2 => $p) { if($table2 == 'p2') { $msg .= "$p, "; } } $sender->sendMessage($msg); return;// and public function getPlayer($p1) { if($this->provider == "SQL") { $a = $this->db->query("SELECT * FROM player1 WHERE p1='$p1';"); $b = $a->fetchArray(SQLITE3_ASSOC); return $b; } } } Bad english, sorry
PHP: if($this->db->error !== null){ $this->getLogger()->warning("MySQL Error $this->db->errno."#: ".$this->db->error); return;}$this->db->fetchAssoc($a);
PHP: public function getPlayer($p1) { if($this->provider == "SQL") { $a = $this->db->query("SELECT * FROM player1 WHERE p1='$p1';"); $b = $a->fetchArray(SQLITE3_ASSOC); return $b; if($this->db->error !== null){ $this->getLogger()->warning("MySQL Error ".$this->db->error); return; } $this->db->fetchAssoc($a); } } } No error
PHP: $sql = "SELECT * FROM player1 WHERE p1='$p1';";if(!$r = $this->db->query($sql)){ $this->getLogger()->warning("MySQL Error ".$this->db->errorno."#: ".$this->db->error);}