title: delete from one SQL table and add to another
body: <p>I realize this is probably a simple execute problem, but I am stuck. I have the record <strong>DELETE</strong> just fine, but it does not show up in the second table.</p>
  
  <pre><code> &lt;?php
     if( $_SERVER['REQUEST_METHOD']=='GET' &amp;&amp; isset( $_GET['job_numb'] ) ){
     $job_numb = filter_input( INPUT_GET, 'job_numb', FILTER_SANITIZE_STRING );
     }
   ?&gt;
  </code></pre>
  
  <p>Note the server request from the URL above. This is how I passed my <code>$job_numb</code>. Now I am going to <strong>pick it back up</strong> in my <code>SELECT</code> query below:</p>
  
  <pre><code> $servername = "localhost";
   $username = "ccccc";
   $password = "xxxxx";
   $dbname = "jobs_users";
  
       // Create connection
       $conn = mysqli_connect($servername, $username, $password, $dbname);
  
       // Check connection
       if (!$conn) {
            die("Connection failed: " . mysqli_connect_error());
       }
  
   $sql = "SELECT * FROM jobs_canjobs WHERE job_numb = $job_numb";
   $results = mysqli_query($conn, $sql);
  
   if ($row = mysqli_fetch_array($results)){
        $job_name = $row['job_name'];
        $comments = $row['comments'];
        $due_date = $row['due_date'];
        $show_date = $row['show_date'];
        $attachment1 = $row['attachment1'];
        $requestor = $row['requestor'];
        $status = $row['status'];
        $req_email = $row['req_email'];
        $Property = $row['Property'];
        $assignee = $row['assignee'];
        $assign_email = $row['assign_email'];
        $AE = $row['AE'];
   }else{
        echo 'no records found';
   }
        mysqli_close($conn);
  ?&gt;
  </code></pre>
  
  <p>I could also put these results into an array and pick from each of them, but at the time of this writing this is how the code existed <strong>so I did not edit that part</strong>.</p>
  
  <p>Now with all of these variables loaded from the MySQL that corresponds to the queried <code>$job_numb</code>, you can add them into a page for results. </p>