<?

	$db_front = mysql_pconnect("172.29.42.1","ruchita-comtrn","dfsTYuu%%$453") or die ("can not connect to db");
	$database_front= mysql_select_db("companytrends",$db_front)or die ("can not select to udb");

	$select_query1="select * from politician_twitter where post_time>='2013-11-16 00:00:00' and post_time< '2013-11-17 00:00:00'";
	$rs = mysql_query($select_query1);
$st="";	
	while($rw = mysql_fetch_array($rs)){

        $db_front1 = mysql_pconnect("172.29.50.5","ruchita-comtrn","dfsTYuu%%$453") or die ("can not connect to db");
        $database_front1= mysql_select_db("companytrends",$db_front1)or die ("can not select to udb");


		$ins_query = "INSERT INTO `companytrends`.`politician_twitter`(`id`,`text`,`source`,`url`,`post_time`,`search_name`,`search_id`,`username`,`screen_name`,`location`,`profile_image`,`entities`,`post_type`,`post_users`,`followers_count`,`retweet_count`,`user_type`,`flag`)VALUES('".$rw[id]."','".mysql_real_escape_string($rw[text])."','".mysql_real_escape_string($rw[source])."','".mysql_real_escape_string($rw[url])."','".$rw[post_time]."','".$rw[search_name]."','".$rw[search_id]."','".$rw[username]."','".$rw[screen_name]."','".mysql_real_escape_string($rw[location])."','".mysql_real_escape_string($rw[profile_image])."','".mysql_real_escape_string($rw[entities])."','".$rw[post_type]."','".$rw[post_users]."','".$rw[followers_count]."','".$rw[retweet_count]."','".$rw[user_type]."',".$rw[flag].")";
                                        //print $ins_query."\n";
                    //                   exit;
					mysql_query($ins_query);
				//	sleep(1);//exit;
	}


?>