<?
  $dbhost = 'localhost:8889';
  $dbuser = 'root';
  $dbpass = 'root';
  $dbname = 'fadb_fa';
  $conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');
  mysql_select_db($dbname);
 
  $arr = array();
  $result = mysql_query("SELECT user_id, user_username, user_flickr_username, user_flickr_id from user where user_flickr_id IS NOT NULL");
  
  while($obj = mysql_fetch_object($result)) {
    $arr[] = $obj;
  }
  
  // JSON headers from from http://snippets.dzone.com/posts/show/5882
  header('Cache-Control: no-cache, must-revalidate');
  header('Expires: Mon, 26 Jul 1997 05:00:00 GMT');
  header('Content-type: application/json');
 
  print json_encode($arr);
?>