Php Classess...db Query

[poyor7]

Hi...

I start with DB first

var $member_table = "member_log";
-consist of lid,Uid,action,ctime,ldesc,ip
var $member_info_table = "member_info";
-consist of member_id,name,location
where (Uid=member_id)

The Code Currently querying only member_table

function search_Log_Query() {

$use_where_stmt = false;
$this->strQuery = " Select action, ldesc, ctime , ip FROM " . $this->member_table ."" ;

if (strlen($this->l_desc) != 0){ 
if ($use_where_stmt) {
$this->strQuery .= " and ";
} else {
$this->strQuery .= " WHERE " ; 
$use_where_stmt = true ;
} 
$this->strQuery .= " ldesc like '%" . $this->l_desc . "%'"; 
$use_where_stmt = true ; 
} 

} 

Question....i need to retrieve also some data from member_info_table....which is location.So i need only JOIN query only n how should do it in this line? :

$use_where_stmt = false;
$this->strQuery = " Select action, ldesc, ctime , ip FROM " . $this->member_table ."" ; 

Regards
Poyor7

[jstgermain]

$use_where_stmt = false;
$this->strQuery = " Select action, ldesc, ctime , ip FROM " . $this->member_table .", member_info_table" ; 

add in the other field names that are in the member_info_table after "ip" and it should work