[MySQL][PHP]Pobranie dwóch tabel Opcje

[tenloginjestzaje...]

Witam mam problem, nie wiem jak pobrać dwie tabele, do pobrania jednej używam:

[PHP] pobierz, plaintext 
$query1 = mysql_query("SELECT DISTINCT `tag` FROM `comments`");
while($row = mysql_fetch_assoc($query1)){echo '';}
[PHP] pobierz, plaintext 

Potrzebuje jeszcze pobrać:

[PHP] pobierz, plaintext 
$query1 = mysql_query("SELECT DISTINCT `tag` FROM `tags`");
while($row = mysql_fetch_assoc($query1)){echo '';}
[PHP] pobierz, plaintext 

Tak żeby w jednym echo były wniki z dwóch tabel. Dziękuje

[tenloginjestzaje...]

[PHP] pobierz, plaintext 
<?php
 
define('_DB_NAME_', 'xxx');
 
define('_DB_SERVER_', 'xxx');
 
define('_DB_USER_', 'xxx');
 
define('_DB_PASSWD_', 'xxx');
 
 
class MySQL{
 
	var $m;
 
	var $result;
 
	public $errors = array();
 
	public function __construct(){
 
		$this->m = mysql_connect(_DB_SERVER_, _DB_USER_, _DB_PASSWD_);
 
		$this->query('SET charset utf8');
 
		$this->errors = array(mysql_errno($this->m), mysql_error($this->m));
 
	}
 
	public function query($sql){
 
		$this->result = mysql_db_query(_DB_NAME_, $sql, $this->m);
 
		$this->errors = array(mysql_errno($this->m), mysql_error($this->m));
 
	}
 
	public function num_rows(){
 
		return mysql_num_rows($this->result);
 
	}
 
	public function affected_rows(){
 
		return mysql_affected_rows($this->m);
 
	}
 
	public function sh_result(){
 
		return $this->result;
 
	}
 
	public function id(){
 
		return mysql_insert_id($this->m);
 
	}
 
	public function escape($string){
 
		return mysql_real_escape_string(trim($string), $this->m);
 
	}
 
	public function fetch_array(){
 
		return mysql_fetch_array($this->result, MYSQL_ASSOC);		
 
	}
 
	public function result(){
 
		return mysql_result($this->result, 0);
 
	}
 
	public function __destruct(){	  
 
		$this->errors = array(mysql_errno($this->m), mysql_error($this->m));
 
		//mysql_close($this->m);
 
	}
 
}
 
 
?>
[PHP] pobierz, plaintext 

Drugi config rózni się jedynie danymi do sql. Nie bardzo wiem jak to ogarnąć.

Ten post edytował tenloginjestzajety 4.07.2015, 21:38:08