function cambiar($id_user, $id_ronda, $valor)
{
$sql = "UPDATE `users_ronda` SET `marcado` = '" . $valor . "' WHERE `id_user` ='" . $id_user . "' AND `id_ronda` = '" . $id_ronda . "'";
$result = mysql_query($sql) or die(mysql_error());
$users_ronda = users_ronda($id_ronda);
$a_pagar = pagar_ronda($id_ronda);
while ($row = mysql_fetch_array($users_ronda)) {
$sql = "UPDATE `users_ronda` SET `saldo` = '" . $a_pagar . "' WHERE `id_user` ='" . $row['id_user'] . "' AND `id_ronda` = '" . $id_ronda . "' AND `marcado`=1";
$result = mysql_query($sql) or die(mysql_error());
}
}
$id_ronda = $row['id_ronda'];
$sql = "SELECT `id_user` FROM `rondas` WHERE `id_ronda` = '" . $id_ronda . "'";
$id_user_ronda = $db->select_unico($sql);
$sql2 = "SELECT `user` FROM `users` WHERE `id_user` = '" . $id_user_ronda . "'";
$user_ronda = $db->select_unico($sql2);
$sql3 = "SELECT `precio` FROM `rondas` WHERE `id_ronda` = '" . $id_ronda . "'";
$precio_ronda = $db->select_unico($sql3);
echo "<h3>" . desc_ronda($id_ronda) . ", " . $precio_ronda . "€ pagados por " . $user_ronda;
echo "</h3>Tus amigos en la ronda son: <br /><br />";
echo "<li>Tú, que pagas " . mi_saldo($id_user, $id_ronda) . "€";
if ($row['marcado'] == 1) {
echo "<input type=\"checkbox\" name=\"" . $id_ronda . "\" checked=\"checked\" /></li>";
} else {
echo "<input type=\"checkbox\" name=\"" . $id_ronda . "\" /></li>";
}
$users_ronda = users_ronda($id_ronda);
while ($row = mysql_fetch_array($users_ronda)) {
if ($row['id_user'] != $id_user && $row['marcado'] == 1) {
echo "<li>" . user($row['id_user']) . " que paga " . $row['saldo'] . "</li>";
} elseif ($row['id_user'] != $id_user && $row['marcado'] == 0) {
echo "<li>" . user($row['id_user']) . " que <strong>NO</strong> paga" . "</li>";
}
}
echo "<br /><hr />";
}
echo "</ul>";
?>
<p><button name="enviar" value="Enviar" type="submit">Actualizar</button></p>
</form>
<?php
echo "<p>¿Te falta <a href=\"crear_ronda.php?id_fiesta=" . $id_fiesta . "\">añadir alguna ronda</a>?";
