static public function getHistory() { $allTimes = SecurityCollection::getDates(); if(loggedAdmin()) //if it is admin $id_client= mysql_real_escape_string($_GET['userid']); elseif(isset($_SESSION['login'])) $id_client= mysql_real_escape_string($_SESSION['login']); else die('unauthorized access!'); //$id_client = mysql_real_escape_string($_GET['userid']); $condition = " s.id_client = '$id_client' AND"; // var_dump($allTimes); $rows=array(); foreach($allTimes as $key=>$thisTime): $query = " SELECT s.id, i.fund_name iname, s.quantity, ca.name custody, s.created_at, i.ISIN code FROM security s, fund i, custody_ac ca "; $query.= " WHERE $condition i.id = s.id_isin AND ca.id = s.id_custody AND s.created_at = (SELECT MAX(created_at) FROM security ss WHERE ss.id_client = s.id_client AND ss.id_custody = s.id_custody AND ss.id_isin = s.id_isin AND ss.created_at < '".$thisTime['created_at']."') "; // echo "$query<br/><br/>"; $qres = mysql_query($query) or die('could not execute query'.$query); while($x = mysql_fetch_assoc($qres)) $rows[$key][] = $x; endforeach; //var_dump($rows); //echo'<hr/><hr/>'; /*if(1==0) foreach($rows as $row): echo'<hr/><hr/>'; var_dump($row); echo'<hr/><hr/>'; endforeach;*/ return($rows); }