delete row

viveleroi0

I have an html form that has php loading information from a mysql database. I have made each row of information appear in a correspronding row of form input text boxes. Those are forms in and of thermselves. When a user clicks the delete submit button, it should delete that row from the database, but leave the others alone. A simple post method of passing the variables and

$result=mysql_query("DELETE FROM Carts WHERE OrderName=\"$DeleteName\" AND OrderPrice=\"$DeletePrice\" AND OrderID=\"$DeleteID\" AND CartID=\"$DeleteSess\" LIMIT 1");

code does not work. But if I replace the variables with the actual form input and not the variables, it works. So the variables are somehow not being translated.

sarahk

as a debugging tool change your code to:

$sql = "DELETE FROM Carts WHERE OrderName='$DeleteName' AND OrderPrice='$DeletePrice' AND OrderID='$DeleteID' AND CartID='$DeleteSess' LIMIT 1";
echo $sql;
exit; 
$result=mysql_query( $sql);

and look at what is echo'd out - if it doesn't make sense to you it won't make sense to MySql. Try copying it from the browser to phpMyAdmin and see if you get an error message from there. The cause should become clear.

malbera

if register_globals are off, use $POST['DeleteName'] instead of $DeleteName
the same with all posted vars
(in case you use post for submitting the form)
if not, use get ($GET['var'])

hope that helps

cboston

I have done somthing similar to this. The best way I have found is to this is to have an extra column in your database that has an autoincrementing int in it. when you read the info from the database and create the form, just include the "index" number as a hidden field. this makes the query simple to delete an entire row from the database. Also it takes care of its self when adding a row.

let me know how this works.