function getFavoriteCount()
{
$sql = "SELECT tweet.text, tweetpopularity.favoriteCount FROM `tweetpopularity` \n\t\t\t\t\tINNER JOIN tweet ON tweetpopularity.tweetId = tweet.tweetId \n\t\t\t\t\twhere favoriteCount != 0 group by favoriteCount limit 10 offset 10";
$twitterDB = new TwitterDB();
$conn = $twitterDB->getDBConnection();
$result = $conn->query($sql);
$tweets = array();
if ($result->num_rows > 0) {
// output data of each row
$i = 0;
while ($row = $result->fetch_assoc()) {
$tweets[$i]["text"] = $row["text"];
$tweets[$i]["favoriteCount"] = $row["favoriteCount"];
settype($tweets[$i]["favoriteCount"], "integer");
$i++;
}
}
$twitterDB->closeDBConnection($conn);
return $tweets;
}
