Delete not working

aftabp · April 17th, 2009, 08:44 AM

an someone please tell me why isnt my delete working?

PHP Code:


			
<?php
include('includes/config.php');
echo $_REQUEST['id'];
if (isset($_REQUEST['submit']) && $_REQUEST['submit'] == "Delete") {
?>
<form action="slett_ansvarlig.php?id=<?php echo $_REQUEST['id']; ?>" method="post">
<?php
$sql = "DELETE * FROM ansvarlig where a_id=" . $_REQUEST['id'];
$result = mysql_query($sql)
         or die('Could not delete; ' . mysql_error());
}
?>
<input type="submit" value="Delete" />
</form>

i do get a value when i run:

PHP Code:


			
echo $_REQUEST['id'];

mallsop · April 24th, 2009, 12:37 PM

I think you may need a database conncection id here for php5+ :
$result = mysql_query($sql);

$result = mysql_query($sql, $dbconnid);

otherwise next step would be to echo out the query to the screen, then cut and past it into your mysql admin window and see if it works there.

and you are doing a method=POST, not a GET.
rather set your request id as a input type=hidden varaible, and it'll be there upon post.

cheers. -m
---

selva_dhivya · May 7th, 2009, 03:00 PM

You must pass the connection Identifier.visit http://in.php.net/manual/en/function.mysql-query.php