Einmal in der DB einfügen anstatt 16mal

Code:                   In Zwischenablage kopieren (nur IE)

---

$sql = "SELECT id, name, spiel, gewonnen FROM runde1 ORDER BY id"; $result = mysql_query($sql) OR die(mysql_error()); while($row = mysql_fetch_assoc($result)) { $gewonnen = $row['gewonnen']. ""; $id = $row['id']. ""; $name = $row['name']. ""; ?> <table width="200" bordercolor="#FFFFFF" bgcolor="#000000"> <tr> <form name="los" method="post" action=""> <td> <div align="left"><strong> <input name="id" type="text" value="<?php echo "$id";?>"> <br> <?php echo "$name"; ?> <font color="#FF0000">Gewonnen:</font><?php echo "$gewonnen"; ?></strong></div> <input type="submit" name="submit" value="Gewonnen"> </td> </form> </tr> </table><?phpif (isset($_POST['submit'])) {mysql_query("UPDATE runde1 SET gewonnen='".($gewonnen+1)."' WHERE id='$id'"); }}mysql_close($conn);?>1">$sql = "SELECT<br/>        id,<br/>        name,<br/>        spiel,<br/>        gewonnen           <br/>     FROM                <br/>         runde1 ORDER BY id"; <br/>    $result = mysql_query($sql) OR die(mysql_error());<br/>    while($row = mysql_fetch_assoc($result)) <br/>    {<br/>    $gewonnen = $row['gewonnen']. "";<br/>    $id = $row['id']. "";<br/>    $name = $row['name']. "";<br/>    ?><br/>  <table width="200" bordercolor="#FFFFFF" bgcolor="#000000"><br/>    <tr><br/>    <form name="los" method="post" action=""><br/>      <td><br/>      <div align="left"><strong><br/>        <input name="id" type="text" value="<?php echo "$id";?>"><br/>        <br><br/>        <?php echo "$name"; ?> <font color="#FF0000">Gewonnen:</font><?php echo "$gewonnen"; ?></strong></div><br/>      <input type="submit" name="submit" value="Gewonnen"><br/>      </td><br/>      </form><br/>    </tr><br/>  </table><br/><?php<br/>if (isset($_POST['submit'])) {<br/>mysql_query("UPDATE runde1 SET gewonnen='".($gewonnen+1)."' WHERE id='$id'");    <br/> }<br/>}<br/>mysql_close($conn);<br/>?><br/>

---