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>?";