Delete from mysql

[Dennis10]

Using the following code I can retrieve information from a mysql table and have the results displayed on the same page.

Is it possible to add a delete option next to each of the returned results to allow user to delete unwanted records

<h3>Please select your vehicle type</h3>

<form action = "<?php echo $_SERVER['PHP_SELF']; ?>" method="POST">
Please select your vehicle type:

<select name="vehicle">
<option value="car">Car</option>
<option value="van">Van</option>
<option value="truck">Truck</option>
<option value="bus">Bus</option>
</select>

<input type="submit" value ="Search for tyres"/>

</form>

<?php

$vehicle = $_POST['vehicle'] ;

if ( $vehicle == '' )
{
// print "
no vehicle selected ..." ;
}
else
{
$host = "localhost";
$user = "root";
$password = "**";
$database = "**";
$table = "tyre";

$connection = mysql_connect($host, $user, $password)
or die ("Couldn't connect to server");

$db = mysql_select_db($database, $connection)
or die ("Couldn't connect to database");

$result = mysql_query("SELECT * FROM $table WHERE vehicle = '" . $vehicle . "'")
or die(mysql_error());

print "
Available tyres for: $vehicle

" ;

  echo "<table border='1'>";
  echo "<tr> <th>Vehicle</th> <th>Size</th> <th>Brand</th> <th>Price</th> </tr>";

  // keeps getting the next row until there are no more to get
  while($row = mysql_fetch_array( $result )) {
      // Print out the contents of each row into a table
      echo "<tr><td>"; 
      echo $row['Vehicle'];
      echo "<td>"; 
      echo $row['Size'];
      echo "<td>"; 
      echo $row['Brand'];
      echo "</td><td>"; 
      echo $row['Price'];
      echo "</td></tr>"; 
  } 

  echo "</table>";

}

[coldwerturkey]

I don't know if this is the best way or not, I'm sure someone will complain, but you can add the link below in your while loop,

$id = $row['id'];
echo "<a href='?delete=01&id={$id};'>Delete</a>";

Than place this at the start of the script,

if($_GET['delete'] == 01){
    $delete = $_GET['id'];
    mysql_query("DELETE FROM $table WHERE id='{$delete}'") or die(mysql_error());
}

(the "id" is the best way to do it if your table has it, but you can do it by vehicle, names, etc,)

better explanation; http://w3schools.com/php/php_mysql_delete.asp

[Dennis10]

Thanks Coldwetturkey

[Dennis10]

I am getting a delete option for each record but they are appearing above the table of results e.g.

Delete
Delete

Vehicle ID Brand Size Price
A 1 BB 20" 19.99
B 2 BA 22" 29.99

code:

print "<br>Available tyres for: $vehicle<br><br>" ;

	echo "<table border='1'>";
	echo "<tr> <th>Vehicle</th> <th>ID</th> <th>Size</th> <th>Brand</th> <th>Price</th> </tr>";

	// keeps getting the next row until there are no more to get
	while($row = mysql_fetch_array( $result )) {
		 // Print out the contents of each row into a table

		 $id = $row['ID']; 
		 echo "<a href='?delete=01&id={$id};'>Delete</a>"; 
		 echo "<tr><td>"; 
		 echo $row['Vehicle'];
		 echo "<td>"; 
		 echo $row['ID'];
		 echo "<td>"; 
		 echo $row['Size'];
		 echo "<td>"; 
		 echo $row['Brand'];
		 echo "</td><td>"; 
		 echo $row['Price'];
		 echo "</td></tr>"; 
	} 

	echo "</table>";

[Dennis10]

How can I get the delete options to appear beside each returned record?

[bradgrafelman]

Fix the HTML - put the delete link inside the table row.