showEverytime.php

<?php
	// TubeKit Beta 4
	// http://www.tubekit.org
	// Author: Chirag Shah
	// Date: 10/22/2010
	require_once("header.php");
	$id = $_GET['video_id'];
	$query = "SELECT * from " .$prefix . "_everytime WHERE video_id=$id";
	$result = mysql_query($query) or die(" ". mysql_error());
	echo "<br><br><table border=1 class=\"body\">\n";
	$count = 1;
	echo "<tr><th>Crawl #</th><th>Crawl date</th><th>Rank</th><th>Views</th><th>Ratings</th><th>Avg Rating</th><th>Comments</th><th>Responses</th><th>Favorited</th>	</tr>";
	while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) 
	{
		echo '<tr><td align=right><font size=2>' . $count . '</td>';
		echo '<td><font size=2>' . $line['collectiondate'] . '</td>';
		echo '<td align=right><font size=2>' . $line['rank'] . '</td>';		
		echo '<td align=right><font size=2>' . $line['view_count'] . '</td>';
		echo '<td align=right><font size=2>' . $line['rating_count'] . '</td>';
		echo '<td align=right><font size=2>' . $line['rating_avg'] . '</td>';
		echo '<td align=right><font size=2>' . $line['comment_count'] . '</td>';
		echo '<td align=right><font size=2>' . $line['response_count'] . '</td>';
		echo '<td align=right><font size=2>' . $line['favorite_count'] . '</td>';
		echo '<td align=right><font size=2>' . $line['related_id'] . '</td>';
		echo "</tr>\n";
		$count++;
  	}
	echo "</table>\n";
	require_once("footer.php");
?>