PHP CLASS DB QUERY
Posted: Tue May 23, 2006 9:45 pm
Hi....
I've problem on how to use JOIN query in PHP class...currently my coding is querying one table....so my question is what should i add in my existing code..i mean i this particular line:
The Database:
var $member_table = "member_log";
var $member_info_table = "member_info";
Regards
Poyor7
I've problem on how to use JOIN query in PHP class...currently my coding is querying one table....so my question is what should i add in my existing code..i mean i this particular line:
Code: Select all
$this->strQuery = " Select action, ldesc, ctime , ip FROM " . $this->member_table ."" ;var $member_table = "member_log";
var $member_info_table = "member_info";
Code: Select all
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 ;
}
}Poyor7