$card['deckid'], 'name' => $card['deckname']); $deckid = $card['deckid']; $mn = mysql_fetch_assoc(sql("SELECT COUNT(*) AS c FROM cards WHERE deck = $deckid")); $mn = $mn['c']; if ($pos > $mn) { $error = "That number is too big. You don't even have that much cards in your deck."; } else if ($pos < 1) { $error = "A position is at least one..."; } else { sql("UPDATE cards SET number = 0 WHERE id = $cardid"); sql("UPDATE cards SET number = number - 1 WHERE number > " . $card['number']); sql("UPDATE cards SET number = number + 1 WHERE number >= $pos"); sql("UPDATE cards SET number = $pos WHERE id = $cardid"); sql("UPDATE deck_study SET need_check = 1 WHERE deck = $deckid"); header("Location: view-deck-$deckid"); } require("tpl/deck/ef.php");