Drupal Users Group

$_csv_data = 'User Id, User Name, User Email, User Status, User Created Date, User Last Access Date'. "\n";
header("Content-type: application/octet-stream");
header("Content-Disposition: attachment; filename=\"users-data.csv\"");
$result = db_query('SELECT DISTINCT u.uid, u.name, u.mail as email, u.status, u.created, u.access FROM {users} u LEFT JOIN {users_roles} ur ON u.uid = ur.uid WHERE u.uid > 0');
while ($account = db_fetch_object($result))
{
$created = date("m.d.y", $account->created);
$access = date("m.d.y", $account->access);
$_csv_data .= $account->uid.','.$account->name.','.$account->email.','.$account->status.','.$created.','.$access . "\n";
}
echo $_csv_data;