Untitled

$sql = 'SELECT
        users.uid,
        pv2.value AS firstname,
        pv3.value AS lastname
  FROM {users}
        LEFT JOIN {profile_values} AS pv1 ON (users.uid = pv1.uid)
        LEFT OUTER JOIN {profile_values} AS pv2 ON (users.uid = pv2.uid AND pv2.fid = "5")
        LEFT OUTER JOIN {profile_values} AS pv3 ON (users.uid = pv3.uid AND pv3.fid = "6")
  WHERE pv1.fid = "1"
         AND pv1.value = ""
         AND pv2.value <> ""
         AND pv3.value <> ""
  ORDER BY created DESC
  LIMIT 0, 200';

  if ($results = db_query($sql)) {
    while ($row = db_fetch_object($results)) {
      $display_name = $row->firstname .' '. $row->lastname;
      dpm("settings display name for ". $display_name);
      $update_sql = "UPDATE profile_values SET value = '%s' WHERE uid = %d and fid = 1";
      db_query($update_sql, array($display_name, $row->uid));
    }
  }