DATE_SUB(NOW(),INTERVAL 1 YEAR)"; $data3 = mysql_result(mysql_query("SELECT data_sesji FROM forex_his WHERE nazwa='" . $waluta . "' ORDER by data_sesji DESC LIMIT 1"),0); $data1 = mysql_result(mysql_query("SELECT data_sesji FROM forex_his WHERE nazwa='" . $waluta . "' AND data_sesji >= DATE_SUB('" . $data3 . "',INTERVAL 1 YEAR)"),0); } else { $data1=$rok1 . "-" . $miesiac1 . "-" . $dzien1; $data3=$rok2 . "-" . $miesiac2 . "-" . $dzien2; } $result=mysql_query("SELECT close FROM forex_his WHERE nazwa='" . $waluta . "' AND data_sesji >='" . $data1 . "' AND data_sesji<='" . $data3 . "'"); $ile_notowan=mysql_num_rows($result); if($ile_notowan<2 || ($data1 > $data3)) {include("rysuj_wyk_blad.php"); exit;} if ($dzien1 =="") { $polowa_notowan = round($ile_notowan / 2); $data2 = mysql_result(mysql_query("SELECT data_sesji FROM forex_his WHERE nazwa='" . $waluta . "' ORDER BY data_sesji DESC LIMIT " . $polowa_notowan . ", 1"),0); } else { $polowa_notowan = round($ile_notowan / 2); $data2 = mysql_result(mysql_query("SELECT data_sesji FROM forex_his WHERE nazwa='" . $waluta . "' AND data_sesji >='" . $data1 . "' AND data_sesji<='" . $data3 . "' ORDER BY data_sesji DESC LIMIT " . $polowa_notowan . ", 1"),0); } $wyn=mysql_fetch_array(mysql_query("SELECT *, max(high), min(low) FROM forex_his WHERE nazwa='" . $waluta . "' AND data_sesji >='" . $data1 . "' AND data_sesji<='" . $data3 . "'")); $max=$wyn["max(high)"]; $min=$wyn["min(low)"]; $max=str_replace(",",".", $max); $min=str_replace(",",".", $min); $data_1 = $data1; $data_2 = $data2; $data_3 = $data3; mysql_close($connection); include("rysuj_wyk_duzy.php");*/ ?>