Furyan

galera, seguinte, criei um simples script para mostrar a list de quests de um jogo! porem eu queria fazer um script para atualizar as quests, dados que ficam faltando e tal... isso é o que tenho até agora: atualizar.php <?php include "include/config.php"; include "include/language.php"; $id = $_GET['id']; $query = "SELECT * FROM hero_quests WHERE id='$id'"; $result = mysql_query("SELECT * FROM hero_quests"); $num = mysql_num_rows($result); mysql_close(); $i = 0; while ($i < $num) { $tipo = mysql_result($result, $i, "tipo"); $_GET['id'] = mysql_result($result, $i, "id"); $level = mysql_result($result, $i, "level"); $localizacao = mysql_result($result, $i, "localizacao"); $quest = mysql_result($result, $i, "quest"); $recompensa = mysql_result($result, $i, "recompensa"); $descricao = mysql_result($result, $i, "descricao"); $item = mysql_result($result, $i, "item"); $conversa = mysql_result($result, $i, "conversa"); $dicas = mysql_result($result, $i, "dicas"); ?> <form action="atualizado.php" method="POST" > <table width="778"> <tr> <td width="90"> <?php echo "$lang_type"; ?>: </td> <td width="678"> <select size="1" name='ud_tipo'> <option selected><?php echo "$tipo"; ?></option> <option>Quest</option> <option>Justice</option> <option>Story</option> </select></td> </tr> <tr> <td width="90"> <tr> <td width="90"> <?php echo "$lang_level"; ?>: </td> <td width="678"> <input type="text" value='<?php echo "$level"; ?>' name='ud_level' maxlength='3' size="1"/></td> </tr> <tr> <td width="90"> <?php echo "$lang_location"; ?>: </td> <td width="678"> <select size="1" name='ud_localizacao'> <option selected><?php echo "$localizacao"; ?></option> <option>Ho-Nam - Dragon Castle</option> <option>Ho-Nam - Highlands</option> <option>Ho-Nam - Venom Swamp</option> <option>Ho-Nam - Spirit Spire</option> <option>Sa-Chum - Southern Plain</option> <option>Sa-Chum - Central Isle</option> <option>Sa-Chum - Mudo Island</option> </select></td> </tr> <tr> <td width="90"> <?php echo "$lang_quest"; ?>: </td> <td width="678"> <input type='text' value='<?php echo "$quest"; ?>' name='ud_quest' maxlength='200' size="58"/></td> </tr> <tr> <td width="90"> <?php echo "$lang_reward"; ?>: </td> <td width="678"> <input type='text' value='<?php echo "$recompensa"; ?>' name='ud_recompensa' maxlength='200' size="58"/></td> </tr> <tr> <td valign="top" width="90"> <?php echo "$lang_description"; ?>: </td> <td width="678"> <textarea rows="3" value='<?php echo "$descricao"; ?>' name='ud_descricao' cols="44"></textarea></td> </tr> <tr> <td width="90"> <?php echo "$lang_request"; ?>: </td> <td width="678"> <input type='text' value='<?php echo "$item"; ?>' name='ud_item' maxlength='200' size="58"/></td> </tr> <tr> <td valign="top" width="90"> <?php echo "$lang_conversation"; ?>: </td> <td width="678"> <textarea rows="9" value='<?php echo "$conversa"; ?>' name='ud_conversa' cols="44"></textarea></td> </tr> <tr> <td valign="top" width="90"> <?php echo "$lang_tips"; ?>: </td> <td width="678"> <textarea rows="6" value='<?php echo "$dicas"; ?>' name='ud_dicas' cols="44"></textarea></td> </tr> <tr> <td colspan="2"> <table id="table1" width="471"> <tr> <td> <input name="ud_id" type='hidden' value='<?php echo $_GET['id']; ?>'> <p align="center"><input type='submit' value='<?php echo "$lang_sendbutton"; ?>'> <input type='reset' value='<?php echo "$lang_resetbutton"; ?>'></td> </tr> </table> </td> </tr> </table> <?php ++$i; } ?> atualizador.php <?php include "include/config.php"; $query = "UPDATE hero_quest SET level='" . $_POST['ud_level'] . "', localizacao='" . $_POST['ud_localizacao'] . "', quest='" . $_POST['ud_quest'] . "', recompensa='" . $_POST['ud_recompensa'] . "', descricao='" . $_POST['ud_descricao'] . "', item='" . $_POST['ud_item'] . "', conversa='" . $_POST['ud_conversa'] . "', dicas='" . $_POST['ud_dicas'] . "', tipo='" . $_POST['ud_tipo'] . "', WHERE id='" . $_POST['ud_id'] . "'"; echo $query; $checkresult = mysql_query($query); if ($checkresult) echo '<p>Quest atualizada com sucesso!'; else echo '<p>Falha na atualização!'; mysql_close(); ?> como forma de procurar por erros eu coloquei: echo $query; e if ($checkresult) echo '<p>Quest atualizada com sucesso!'; else echo '<p>Falha na atualização!'; para verificar, e ele mostra falha na atualização.. queria saber o que posso fazer :(