<?php

$dbhost = 'wm131.wedos.net';    $dbuser = 'a143892_kodecar';    $dbpass = '8UVLhJrk';   $dbname = 'd143892_kodecar';

$conn = mysqli_connect($dbhost, $dbuser, $dbpass, $dbname);

if($conn->connect_error) { die('Could not connect: ' . $conn->connect_error); }

// SQL select

$select = 'SELECT * FROM  `wp_cf7dbplugin_submits` WHERE  field_name="your-name" ORDER BY `submit_time` DESC LIMIT 1';

// SQL remove



$result = $conn->query($select);

if($result->num_rows > 0) {

    echo $result->num_rows. " rows selected.";

    $row = $result->fetch_assoc();  // assoc array



    $remove = 'DELETE FROM `wp_cf7dbplugin_submits` ORDER BY `submit_time` DESC LIMIT 2';





   echo "Trial klíč: {$row['field_value']}  <br> "."--------------------------------<br>";

   if ($conn->query($remove) == TRUE) {

       echo "Key removed.";

   } else {

       echo "Can't remove key.". $conn->error;

   }



} else {

    echo "No row selected.";

}



$conn->close();

?>