How to delete a post in database (PHP/MySQL)?

[simonyuriko]

Why everytime I want to delete in the SQL-database, it's always the wrong post that got deleted???

Here's the code:
mysql_query("DELETE FROM new WHERE ".mysql_real_escape_string($_GET['id'])." LIMIT 1")

Here's my site where you can test:
http://pc87012.stofanet.dk/~simonpetersen/sy/weblog/test.php
(The server is NOT open 24/7. Please try again later if the link does not work.)

[tsinka]

Hi,

you have to specify the field, e.g.

mysql_query("DELETE FROM new WHERE id =".mysql_real_escape_string($_GET['id']) 

I think there might be another problem with your script ... can you post the code ?

[simonyuriko]

Originally posted by tsinka
Hi,

you have to specify the field, e.g.

mysql_query("DELETE FROM new WHERE id =".mysql_real_escape_string($_GET['id']) 

I think there might be another problem with your script ... can you post the code ? [/B]

<?

$db="log";

$link = mysql_connect("localhost");

//$link = mysql_connect("localhost",root);

if (! $link)

die("Couldn't connect to MySQL");

mysql_select_db($db , $link)

or die("Couldn't open $db: ".mysql_error());

mysql_query("DELETE FROM new WHERE ".mysql_real_escape_string($_GET['id'])." LIMIT 1")or die("Delete Error: ".mysql_error());

mysql_close($link);

?>

[simonyuriko]

It's work now... thanx for the help tsinka 😉