help changing and deleting rows

[cs1h]

Hi,

 

I made a form that lets people change their data on a online form or delete it but its not working. Can anyone see why the forms arn't working. They say that the it has worked but nothing has been changed or deleted.

 

The changing code is

<?php

$email=$_POST['Email']; 
$name=$_POST['name']; 
$title=$_POST['title']; 
$id=$_POST['hiddenField'];
$Abs=$_POST['message']; 
$Art=$_POST['messagetwo']; 

include "dog.php";

mysql_connect($server, $db_user, $db_pass) or die (mysql_error()); 
mysql_select_db("$database") or die(mysql_error()) ; 

mysql_query("UPDATE $table1 SET Title = '$email'
WHERE id = '$id'");

mysql_query("UPDATE $table1 SET Title = '$name'
WHERE id = '$id'");

mysql_query("UPDATE $table1 SET Title = '$title'
WHERE id = '$id'");

mysql_query("UPDATE $table1 SET Abstract = '$Abs'
WHERE id = '$id'");

mysql_query("UPDATE $table1 SET Article = '$Art'
WHERE id = '$id'");

echo "Changes made to $title.<br /> <a href='arteditor.php'>Click here</a> to return to the admin home.";

?>

 

The deletion code is

<?php

$id=$_POST['hiddenField'];

include "dog.php";

mysql_connect($server, $db_user, $db_pass) or die (mysql_error()); 
mysql_select_db("$database") or die(mysql_error()) ;

$sql = "DELETE FROM $table1 WHERE id = '$id'";
$result = mysql_query($sql);
echo "Deletion made to $title.<br /> <a href='arteditor.php'>Click here</a> to return to the admin home.";

?>

 

Can anyone help?

 

Thanks

Colin

 

 

[enoyhs]

First: Do you have variable $table1 defined?

[cs1h]

I know this may seem like a dumb question but how do I defien it?

 

Thanks

[enoyhs]

$table1 = "SomeTableInDatabase";

 

I'm not sure if this is an error but that is the one I currently see that could be.

[cs1h]

I tried making these changes but it didn't work.

 

Any more ideas?

 

Thanks

Colin