Mitgliederinfos

E-Mails aller registrierten Benutzer

[insert_php]

global $wpdb;

$sql_emails = „SELECT display_name, user_email FROM d4wgxpd_users ORDER BY display_name“;

$mails = $wpdb->get_results($sql_emails);
foreach( $mails as $mail) {
echo „$mail->display_name <$mail->user_email>, „;
}

[/insert_php]

Statistik

[insert_php]

$sql_terms = „SELECT terms.name, tax.count FROM d4wgxpd_connections_term_taxonomy AS tax JOIN d4wgxpd_connections_terms AS terms ON tax.term_id = terms.term_id WHERE tax.parent = 4“;

$rows = $wpdb->get_results($sql_terms);

echo „

„;
foreach ($rows as $row) {
echo „

„;
}
echo „

„; echo $row->name; echo „

„; echo $row->count; echo „

„;

[/insert_php]