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; }