@ 2016-08-24T17:42:16Z <?php
$table_arr = array('al5data','al6data');
//if (empty($table_arr)) $table_arr[]=$this->table;
//if (in_array('al5data',$table_arr)) $idfield = 'dataid';
// else $idfield = 'data_id';
//if (empty($id_arr)) $id_arr = $this->id_arr;
$query ="";
foreach ($table_arr AS $table)
{
$idfield = $this->getPriKey($table);
if ('al5data' !== $table) $query .= " UNION ";
$query .= "(SELECT `$idfield`, `pt_last_name`, `pt_first_name`, `start_date`, \"" . $table . "\" AS `table` FROM `" . $table . "`)";
}
$query .= " ORDER BY STR_TO_DATE(`start_date`, '%m/%d/%Y') DESC, `$idfield` DESC LIMIT 0,100";
echo $query;
Enable javascript to submit You have javascript disabled. You will not be able to edit any code.
Output for 7.0.0 - 7.0.33 , 7.1.0 - 7.1.33 , 7.2.0 - 7.2.33 , 7.3.0 - 7.3.33 , 7.4.0 - 7.4.33 , 8.0.0 - 8.0.30 , 8.1.0 - 8.1.27 , 8.2.0 - 8.2.17 , 8.3.0 - 8.3.4 Fatal error: Uncaught Error: Using $this when not in object context in /in/IqbOu:13
Stack trace:
#0 {main}
thrown in /in/IqbOu on line 13
Process exited with code 255 . Output for 5.6.0 - 5.6.40 Fatal error: Using $this when not in object context in /in/IqbOu on line 13
Process exited with code 255 . preferences:dark mode live preview
217.4 ms | 401 KiB | 287 Q