php - Deleting a row from the database based on id from while loop -


i have while loop pops out of blog posts. along these blog posts puts button beside each 1 red x when click want delete post next it. problem? haven't come effective way decide post delete. either deletes post largest id or of posts. give idea of have... (this isn't actual code, idea of it).

       $result = mysql_query("select * post");         while($row = mysql_fetch_array($result){            $somevariable = $row['id'];          $somevariable1 = $row['title'];          $somevariable2 = $row['content'];  ?>         //this form right below here delete button. functions, need how pull correct id***          <form action="" method="post">        <input type="submit" id ="<?php echo $somevariable ?>" value="" class="submit2" onclick="confirmation()">     </form>      <form action="" method="post">       <input type="submit" value="" class="submit3">     </form>          <script type="text/javascript">        <!--         function confirmation() {             var answer = confirm("delete post?")             if (answer){                  <?php                        mysql_query("delete posts id=***");                   ?>               }          }        //-->        </script>     <?php }?> 

the function inside javascript issue is. can't seem figure out how give right id. raw php easy on me :p.

what want submit form when user confirms delete , handle delete on server.

  function confirmation() {     var answer = confirm("delete post?")        return answer;   } 

this way form submits when user confirms , submit cancels when user not confirm.

include id in hidden element on form named "id". let form submit php page grabs id $_post['id'] , execute sql statement on database redirect list page again.


Comments