[Resolved] Stuff not deleting from a database.

Aybabtu

Hey guys, I am having yet another problem that I can not figure out. I have a php script that runs a delete command on the database. The only problem is that it says that is has been deleted but it does not delete from the database.

My code is as follows...

// set up some variables

// server name
$server = "localhost";

// username
$user = "$name1";

// password
$pass = "$password1";

// database to query
$db = "barberin_Cars";

// open a connection to the database
$connection = mysql_connect($server, $user, $pass);

// formulate the SQL query - same as above
$query = "DELETE FROM 'inventory' where vin = $vin";

// run the query on the database
$result = mysql_db_query($db,$query,$connection);

echo "<center><strong>The car has been deleted from the database</strong></center>";

lanjoky

in your delete statement take off the single quotes around the table name....

$query = "DELETE FROM inventory where vin = $vin";

and where is $vin initiated with a value??

HTH

Aybabtu

I did that and it still will not work. I should mention the fact that is the field is all numbers it will delete... but if it contains letters it will not delete. The field in the database is set to varchar.

lanjoky

where is $vin comming from and what value does it hold?

Aybabtu

The $vin is a feid in a form on the previous page... When you hit submit it runs my code... The $vin contains whatever value the user put in on the previous page, it can be numeric or alpha.

kevinsequeira

$query = "DELETE FROM inventory where vin = '".$vin."'";

reg
kevin

Aybabtu

Thanks for your help guys that last bit of caod resolved my problem. You guys rock.