How do I export the email addresses to a csv file format?

Thanks,

Dave

____________
Another Pro Bono
Version of Icy Phoenix: 1.3.0.53a
Version of PHP: 5.2.9
Version of MySQL: 5.0.81-community-log
Board started: 2009/07/18 - 11:50
Registered Users: 123 as of 17 Sep 09

MySQL Forums?.  

This assumes that your DB prefix is ip_ and that you don't have more than a 1000 users.

Go To

phpMyAdmin > YOUR DB > SQL > Run this Query Code:




> Query results operations > Export > CSV > GO

Lopalong wrote: [View Post]

MySQL Forums?.  

This assumes that your DB prefix is ip_ and that you don't have more than a 1000 users.

Go To

phpMyAdmin > YOUR DB > SQL > Run this Query Code:

Code: [Download] [Hide] [Select]

Code: [Download] [Show]

SELECT COUNT( * ) AS `Rows` , `user_email`
FROM `ip_users`
GROUP BY `user_email`
ORDER BY `user_email`
LIMIT 0 , 1000

> Query results operations > Export > CSV > GO

Thanks a bunch Lopalong.  That is exactly what I needed.

____________
Another Pro Bono
Version of Icy Phoenix: 1.3.0.53a
Version of PHP: 5.2.9
Version of MySQL: 5.0.81-community-log
Board started: 2009/07/18 - 11:50
Registered Users: 123 as of 17 Sep 09

You're welcome, But you could tag it as "Solved" as Staff Members seem to be in short supply at the moment.

Lopalong wrote: [View Post]

You're welcome, But you could tag it as "Solved" as Staff Members seem to be in short supply at the moment.

Done!  Sorry.

____________
Another Pro Bono
Version of Icy Phoenix: 1.3.0.53a
Version of PHP: 5.2.9
Version of MySQL: 5.0.81-community-log
Board started: 2009/07/18 - 11:50
Registered Users: 123 as of 17 Sep 09