database met e-mail adressen

<?
$select = mysql_query("SELECT * FROM `database`");
// Nu de whileloop
    while ($show = mysql_fetch_object($select)){
echo "$show->waarde"; 
}
?> 

<?
$select = mysql_query("SELECT * FROM `database`");
// Nu de whileloop
    while ($show = mysql_fetch_object($select)){
echo "$show->waarde"; 
}
?>

<?php

$query = mysql_query("SELECT e-mail FROM tabel");
while ($res = mysql_fetch_assoc($query)) {
         mail($res['e-mail'], 'test', 'inhoud van de mail');
}
?>

<?php
 
$query = mysql_query("SELECT e-mail FROM tabel");
while ($res = mysql_fetch_assoc($query)) {
         mail($res['e-mail'], 'test', 'inhoud van de mail');
}
?>