Műsortár
$select_shows = mysql_query("SELECT * FROM shows ORDER BY counter DESC"); while($row_shows = mysql_fetch_array($select_shows)) { $actualid=$row_shows['id']; $select_videos = mysql_query("SELECT * FROM videos WHERE show_id=$actualid ORDER BY upload_date DESC LIMIT 4"); $select_count = mysql_query("SELECT * FROM videos WHERE show_id=$actualid ORDER BY upload_date DESC"); $count = mysql_num_rows($select_count); if (mysql_num_rows($select_videos)!=0) { echo "
".$row_shows['name']." | "; echo ""; if ($count>4) {echo "Összes rész";} echo " | "; echo "
";} else {echo " | ";} } echo " |
";
echo " ";
echo "".$row_videos['supplier']." | ";
}
echo "
"; } } ?>