01-11-2009, 10:03 AM
|
|
|
rockin tha trailerpark
Industry Role:
Join Date: May 2001
Location: ~Coastal~
Posts: 23,088
|
Quote:
Originally Posted by BigBen
Quality posts lately. 
Here's another way using built-in WP functions so you don't have to mess with the mysql stuff (tested in 2.7):
Code:
<?php
require_once('example.com/wp-load.php');
$email_list = $wpdb->get_results("SELECT DISTINCT comment_author_email FROM $wpdb->comments WHERE comment_author_email != ''");
foreach($email_list as $email) {
echo $email->comment_author_email . "\n";
}
|
pwnd |
|
|