Twitter API Consulting

Free open source code for Twitter API Engagement Programming


// Copyright (c) 2013 Adam Green. All rights reserved.
// See for licensing of this code.

function get_popular_leader_tweets($where,$start,$results_per_page) {
	global $db;

	$query = "SELECT tweets.tweet_id, tweets.created_at, tweets.tweet_text, tweets.retweet_count, 
		users.user_id, users.screen_name,, users.profile_image_url
		FROM tweets, users
		WHERE tweets.user_id IN
			(SELECT user_id
			FROM leaders)
		AND tweets.user_id = users.user_id 
		ORDER BY tweets.retweet_count DESC 
		LIMIT $start, $results_per_page";

	return $db->select_array($query);

I'm a member of the #140dev Twitter development community - join us for free source code and tutorials: