<?
// include getresponse functions
require_once '/home/chad/www/careersinstantly.com/includes/mailchimp.php';
require_once '/home/chad/www/careersinstantly.com/includes/jsonRPCClient.php';
// connect to get abandons
mysql_connect("localhost", "xxxx", "xxxx");
mysql_select_db("xxxxx");
$dstamp = date('Y-m-d', time()-(60*60*24));
$results = mysql_query("SELECT * FROM user_registration JOIN user_clicks ON user_registration.sub_id = user_clicks.sub_id");

$merged = array()

while ($data = mysql_fetch_array($results)) {
        $first = $data['first'];
        $last = $data['last'];
        $email = $data['email'];
        $key = $data['key'];
        $value = $data['value'];

        $merged[$email]['first'] = $first;
        $merged[$email]['last'] = $last;
        $merged[$email][$key] = $value;

        //echo $first ." ". $last ." ". $email ." ". $key ." ". $value."\n";
}

var_dump($merged);
?>