[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

[kapslokk]

db.class.php

[PHP] pobierz, plaintext 
<?php
class MySQL{
 
	var $m;
 
	var $result;
	private $server;
	private $user;
	private $password;
	private $database;
 
	public $errors = array();
 
	public function __construct($server, $user, $password, $database){
		$this->server = $server;
		$this->user = $user;
		$this->password = $password;
		$this->database = $database;
 
		$this->m = mysql_connect($this->server, $this->user, $this->password);
 
		$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($this->database, $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 

i później:

[PHP] pobierz, plaintext 
$mysql1 = new MySQL('serwer','uzytkownik', 'haslo', 'nazwa_bazy');
$mysql2 = new MySQL('serwer2','uzytkownik2', 'haslo2', 'nazwa_bazy2');
[PHP] pobierz, plaintext 

Ten post edytował kapslokk 4.07.2015, 21:46:35