Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public function join_select($params, $secondary_table, $join_cond) {
- $query = 'SELECT ';
- foreach($params as $val) {
- $query = $query . '`' . $val . '`, ';
- }
- $query = rtrim($query, ',');
- $query = $query . ' FROM `' . $this->table . '` JOIN `' . $secondary_table . '` ON `' . $this->table . '.' . $join_cond . '` = `' . $secondary_table . '.' . $join_cond . '`';
- $query = $this->prep_exec($query, $params);
- $array = $this->fetchAsArray($query);
- return $array;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement