[php] Mehrfachnutzung einer SQL Abfrage

[Cyrill Schumacher]

> Kenn jemand einen einfacheren Weg?

vielleicht ;-)

> $query = "select * from teilnehmer";
> $result = mysql_query($query,$link);
> $num = mysql_numrows($result);
> ?>
> <table width="600" border="0" cellspacing="2">
>    <tr>
> <th><div align="left">Vorname</th>
> <th><div align="left">Name</th>
> <th><div align="left">E-Mail</th>
>    </tr>
>    <tr>
>    <?php

$mails = array();

> for ($i =0; $i < $num; $i++) {
> $row = mysql_fetch_array($result);

$mails[] = $row[email];

> echo "<td>$row[vorname]</td><td>$row[name]</td><td><a 
> href='mailto:$row[email]'>$row[email]</a></td>";
> echo "</tr>";
> }
> echo "<tr>";
> echo "<th>&nbsp;</th><th>&nbsp;</th>";
> echo "<th><div align='left'>";
> $result = mysql_query($query,$link);
> echo "<a href='mailto:";

for ($i =0; $i < count($mails); $i++) {
echo "$mails[$i], ";
}
> echo "'>An alle</a>";
> echo "</div></th>";
> echo "</tr>";
> echo "</table>";

kiri