U2 360° Tour 2011 tweet archive for hashtag
This is an archive of all tweets related to U2's 360° Tour 2011 concert in with the hashtag . We capture as many tweets as possible but can't guarantee to get them all.
";
addthis();
echo "
";
/* Setup vars for query. */
$limit = 50; //how many items to show per page
$page = $_GET['page'];
if($page)
$start = ($page - 1) * $limit; //first item to display on this page
else
$start = 0; //if no page var is given, set start to 0
/* Get data. */
$sql = "SELECT text, from_user, id, profile_image_url, created_at, time FROM $tbl_name ORDER BY time DESC LIMIT $start, $limit ";
# $sql = "SELECT text, from_user, id, profile_image_url, created_at, time FROM $tbl_name ";
$result = mysql_query($sql);
/* Setup page vars for display. */
if ($page == 0) $page = 1; //if no page var is given, default to 1.
$prev = $page - 1; //previous page is page - 1
$next = $page + 1; //next page is page + 1
$lastpage = ceil($total_pages/$limit); //lastpage is = total pages / items per page, rounded up.
$lpm1 = $lastpage - 1; //last page minus 1
/*
Now we apply our rules and draw the pagination object.
We're actually saving the code to a variable in case we want to draw it more than once.
*/
$pagination = "";
if($lastpage > 1)
{
$pagination .= "\n";
}
?>
", "", "", "
");
$text = str_replace($remove, ' ', $text);
$text = unshorturl($text);
$text = twitter_photo_replace(highlight_tweet($text));
// Add this tweet to the list
$tweet_list .= $current_tweet;
echo "
\n";
// Your while loop here
}
?>