\n" . mysql_error());; while($row3=mysql_fetch_row($mysql_result3)) { $warunek .= "a.ID_CNTR = '$row3[0]' OR "; } $warunek = substr($warunek, 0, -4); $query="SELECT MAX(YEAR) as rok_IC from IC_YEAR"; $mysql_result = mysql_query($query, $mysql_link) or die ("$query
\n" . mysql_error());; while($row=mysql_fetch_row($mysql_result)) { $rokIC=$row[0]; } function checkICyear() { global $mysql_link; $query="Select MAX(YEAR) FROM IC_YEAR"; $res=mysql_query($query,$mysql_link); $row=mysql_fetch_row($res); return $row[0]; } $m_year=checkICyear(); //print("max rok:$m_year
"); function cialo_tabeli() { global $mysql_link,$m_year,$currentlang, $recently, $warunek; $q = mysql_query("SELECT d.TITLE, d.ID_TITL, a.ID_JOUR, a.PISSN, a.ID_CNTR, a.SINGLE_SOURCED, a.id_adrs, b.ISO, b.COUNTRY, a.EISSN FROM JOUR a LEFT OUTER JOIN CNTR b ON (a.ID_CNTR = b.ID_CNTR) INNER JOIN JOUR_TITL c ON (a.ID_JOUR = c.ID_JOUR) INNER JOIN TITL d ON (c.ID_TITL = d.ID_TITL) WHERE (d.IS_VERNAC = 'Yes') AND ($warunek) GROUP BY a.ID_JOUR ORDER BY a.ID_JOUR DESC LIMIT 0,20"); while($row = mysql_fetch_row($q)) { $id_journal = $row[2]; $pISSN = $row[3]; $eISSN = $row[9]; echo" $row[0]"; if ($pISSN == '') { print ("$eISSN"); } else { print ("$pISSN"); } echo "".JourICValue($id_journal,$m_year)." "; } } function naglowek_tabeli() { global $currentlang, $rokIC; echo " "._JOURTITL." ISSN INDEX COPERNICUS $rokIC "; } function title_modules() { echo "

:: "._MENU_TOPLIST." ::

"; } include("header.php"); echo"

"; print("
"); print(""); print(""); print("
"); echo"
$nazwabiura - Recently Added Journals
"; print("
 "); print("
"); naglowek_tabeli(); cialo_tabeli(); print("
"); echo" "; include("stopka.php"); echo"
";