title: i can't find the error in my query with the column name in a php var
body: <p>I got the column name from this query:</p>
  
  <pre><code>SHOW COLUMNS FROM $table
  </code></pre>
  
  <p>and I need to delete a ROW with a specific value in a column that I got from the first query:</p>
  
  <pre><code>$con = mysqli_connect("localhost","root","password","database");
  if(isset($_POST['sup'])){
  
      if(mysqli_connect_error()){
          echo "Failed connection";exit;
      }
      $table=$_POST['table_sup'];
  $requet = "SHOW COLUMNS FROM $table";
  $result = mysqli_query($con,$requet);
  if(!$result){
      echo "requete incorrecte";
  }
  $j=0;
  while($row=mysqli_fetch_array($result)){
     $monChamps=$row["Field"];
     $row1[$j]=$monChamps."&lt;br&gt;";
      $j++;
  }
  
  
  $champ1=$_POST['champ_sup'];
  $id=$row1[0];
  $requet1="DELETE FROM $table  WHERE $id='$champ1'";
  if(mysqli_query($con,$requet1)){
      echo '&lt;script language="javascript"&gt;';
      echo 'alert("supprimer")';
      echo '&lt;/script&gt;';
  }}
  </code></pre>