Php OOP queries and connection

[Network_ninja]

Hey guys need help.. I am new in Php OOP programming I am making my connections and queries as OOP here is my code:

 

 

class_lib.php

<?php 

class Mysql_conn { 
var $conn; 

function __construct($hostname,$dbuser,$dbpword,$dbname) { 
	$this->conn = mysql_connect($hostname,$dbuser,$pword,true);
	mysql_select_db($dbname,$this->conn);
}

function query($query){ 
	$result = mysql_query($query,$this->conn)or die('error getting data:'.mysql_error());
	return $result;
}
} 
?>

 

 

And here is my index.php

$db1 = new Mysql_conn("localhost","root","","databasename1");
$db2 = new Mysql_conn("localhost","root","","databasename2"); 

$query = $db1->query("SELECT * FROM tablename");	

 

 

if the query encounter an error such as field name not present,mispelled name or logical error it will not return any error messagge that i have a hard time debugging were the error is...

 

 

but if I have only one database it works fine but in that case that i have two databases that's when the problem occur.... tnx in advance

[PFMaBiSmAd]

mysql_error also needs the $this->conn so that it returns errors from the correct connection.

[Network_ninja]

so you mean i just need to do it like this?

 

mysql_error($this->conn) ???

[Network_ninja]

Thanks for the very quick reply... Now it's working.. that's what im totally missing... tnx