Cannot get my 'delete.php to send to db and mark as dead

Answer 1

Just type in your application:

echo $query = "UPDATE ProfileComments SET status = 'dead' WHERE id = '".$prof->id."' LIMIT 1";

That will ouput the query as a string. If you can see the error immediatly, great. If not try to paste it into phpMyAdmin. This should really help you debug your MySQL!

Hope it helps!

Answer 2

Hi Ralph,

The way I see it, I think it's overkill to make a new object when you're just using the id to update your database :)

I would do it like this:

$id = $_GET['id'];
mysql_query("UPDATE ProfileComments SET status = 'dead' WHERE id = '$id' LIMIT 1") or die(mysql_error());

See if that should do the trick!

Answer 3

This will escape data and cast the id as an integer, which it should be in this case.

mysql_query("UPDATE ProfileComments SET status = 'dead' WHERE id = '". mysql_real_escape_string((int)$prof->id) . "' LIMIT 1");