'name', 'display_name' => 'Name' ), array( 'meta_id' => 'address', 'display_name' => 'Address' ), array( 'meta_id' => 'cps_name', 'display_name' => 'CSP Name' ) ); $tables = array(); $query_fields = array(); $joins = array(); $fcount = 1; array_push($query_fields, "reports.*"); foreach ($fields as $key => $value) { $table_name = "tables" . $fcount++; array_push($query_fields, $table_name.".".$value['meta_id']." AS ".$value['display_name']); array_push($joins, "INNER JOIN reports_meta_values ".$table_name." ON reports.id = ".$table_name.".report_id AND ".$table_name.".meta_id='".$value['meta_id']."'"); } $final_sql = "SELECT " .implode(",", $query_fields) . " FROM reports " . implode(" ", $joins). " WHERE 1"; echo "$final_sql"; ?>
via
Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire