title: I wanna delete rows form datebase, my code was working and deleting rows then just stop, i do not change anything in code?
body: <p>So my code was work perfectly, i was able to remove row. After I update datebase with new data, I wanna delete them to test code again and I was enable to delete.
  I dont know if is problem in xampp, cuz my code work. Don't know what to try to make work again.</p>
  
  <p>this is my delete.php file:</p>
  
  <pre><code>&lt;?php
  //connecting to base
  // include "spoj.php";
  $conn = mysqli_connect('localhost', 'root', '', 'kolegij') or die('Connection error!');
  //Defining rows
  $id = $_GET['id'];
  $query = "DELETE FROM kolegij WHERE id = '$id'";
  
  //delete rows
  mysqli_query ($conn, $query);
  
  if (mysqli_affected_rows($conn)==1) {
  //if rows delete
  ?&gt;
  
              &lt;strong&gt;Kolegij je izbrisan&lt;/strong&gt;&lt;br /&gt;&lt;br /&gt;
  
  &lt;?php
   } else {
  //rows not deleted
  ?&gt;
  
              &lt;strong&gt;Niste uspjeli izbrisati kolegij&lt;/strong&gt;&lt;br /&gt;&lt;br /&gt;
  
  
  &lt;?php
  }
  ?&gt;
  </code></pre>
  
  <p>this is my html code:</p>
  
  <pre><code>&lt;html&gt;
  &lt;head&gt;
  &lt;title&gt;Evidencija Kolegija&lt;/title&gt;
  &lt;meta http-equiv="Content-Type" content="text/html; charset=utf-8"&gt;
  &lt;/head&gt;
  &lt;body&gt;
  &lt;h1&gt;Evidencija Kolegija&lt;/h1&gt;
  &lt;hr&gt;
  &lt;a href="kolegiji.php"&gt;Dodaj novi kolegij&lt;/a&gt;
  &lt;hr&gt;
  &lt;?php
  //connect to datebase
  // include "spoj.php";
  $conn = mysqli_connect('localhost', 'root', '', 'kolegij') or die('Connection error!');
  //ispis svih studenata u bazi sortiranih po id-u
  $sql_upit="SELECT * FROM kolegij ORDER BY id ASC";
  if (!$q=mysqli_query($conn, $sql_upit))
  {
  echo "Nismo uspjeli u čitati kolegije iz baze"."&lt;br&gt;". mysqli_query($conn, $sql_upit);
  die();
  }
  //if rows is === 0 then there is no datea in datebase
  if (mysqli_num_rows($q)==0)
  {
  echo "Nema kolegija u bazi.";
  }
  else {
  echo '&lt;table width="1000" border="1px" cellpadding="2" cellspacing="2"&gt;';
  echo '&lt;tr&gt;&lt;td&gt;&lt;b&gt;Id&lt;/b&gt;&lt;/td&gt;';
  echo '&lt;td&gt;&lt;b&gt;Predmeti&lt;/b&gt;&lt;/td&gt;';
  echo '&lt;td&gt;&lt;b&gt;Profesor&lt;/b&gt;&lt;/td&gt;';
  echo '&lt;td&gt;&lt;b&gt;Status&lt;/b&gt;&lt;/td&gt;';
  //sve dok ima kolegija u bazi
  while ($redak=mysqli_fetch_array($q))
  {
  echo '&lt;tr&gt;&lt;td&gt;'.$redak["id"].'&lt;/td&gt;';
  echo '&lt;td&gt;'.$redak["Predmeti"].'&lt;/td&gt;';
  echo '&lt;td&gt;'.$redak["Profesor"].'&lt;/td&gt;';
  echo '&lt;td&gt;'.$redak["Status"].'&lt;/td&gt;';
  echo '&lt;td&gt;&lt;a href="izmjeni.php?id='.$redak["id"].' "&gt;Uredi kolegij&lt;/a&gt;&lt;/td&gt;';
  </code></pre>
  
  <p>//delete button
      echo 'Obriši
      ';
      }
      echo '';
      }
      ?>
      <hr>
      
      </p>