0){ $parancs2 = "SELECT hun_title, eng_title, filmek.movie_id, title, season, year, nick, wannasee_id, filmek.release_date FROM movies filmek, wannasee megnezendok WHERE (filmek.movie_id = megnezendok.movie_id AND megnezendok.nick='".$nick."' AND filmek.release_date>'".$datetime." 00:00:00' ) ORDER BY filmek.release_date ASC, wannasee_id DESC LIMIT 7" ; $eredmeny2 = mysql_query($parancs2, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error()); $fut_wannaseerows = mysql_num_rows($eredmeny2); print ""; if($fut_wannaseerows>0){ $colorone="#1f1f1f"; $colortwo="#050505"; $tdcolor=$colortwo; while ( $sor2 = mysql_fetch_array($eredmeny2)) { if ($tdcolor==$colorone){ $tdcolor=$colortwo; } else if ($tdcolor==$colortwo){ $tdcolor=$colorone; } $tdcolor_save=$tdcolor; $pieces = explode(" ", $datetime); $date=$pieces[0]; $release_pieces = explode(" ", $sor2['release_date']); $release_date=$release_pieces[0]; $diff = abs(strtotime($release_date) - strtotime($date)); $to_release = floor($diff / (60*60*24)); $release_datepieces = explode("-", $release_date); $release_year=$release_datepieces[0]; $release_nummonth=$release_datepieces[1]; $release_day=$release_datepieces[2]; switch ($release_nummonth) { case 01: $release_month=$txt["january"]; break; case 02: $release_month=$txt["february"]; break; case 03: $release_month=$txt["march"]; break; case 04: $release_month=$txt["april"]; break; case 05: $release_month=$txt["may"]; break; case 06: $release_month=$txt["june"]; break; case 07: $release_month=$txt["july"]; break; case 8: $release_month=$txt["august"]; break; case 9: $release_month=$txt["september"]; break; case 10: $release_month=$txt["october"]; break; case 11: $release_month=$txt["november"]; break; case 12: $release_month=$txt["december"]; break; } print ""; } } else { print "




"; if ($lng=="hun"){ print "Jelenleg nincs semmi."; }else{ print "You don't have any now." ; } } } print ""; ?>