Hulp With Delete Script

Okay, i have a delete script which should work

Code:

---

<?php
$hostname = "localhost";
$db_user = "*******"; // change to your database password
$db_password = "*******"; // change to your database password
$database = "*******"; // provide your database name
$db = mysql_connect($hostname, $db_user, $db_password);
mysql_select_db($database,$db);

$ref = $_GET['RefNum'];
$ok = @mysql_query("DELETE FROM ads WHERE REFNUM='$ref");

if ($ok) {

echo("Advert Deleted");     

  } else {
  echo('<p>Error deleting from database!<br />'.
      'Error: ' . mysql_error() . '</p>');
}

?>

---

I go to delete it and it says deleted, yet when i check to see if it has deleted it hasn't

Help please?

also here is my table structure if it is any help

http://feudel.co.uk/images/advertise...d094f9saga.PNG

DELETE _ FROM

your missing whatever is in between DELETE and FROM

Quote:

---

Originally Posted by Johnnikins

Okay, i have a delete script which should work

Code:

---

<?php
$hostname = "localhost";
$db_user = "*******"; // change to your database password
$db_password = "*******"; // change to your database password
$database = "*******"; // provide your database name
$db = mysql_connect($hostname, $db_user, $db_password);
mysql_select_db($database,$db);

$ref = $_GET['RefNum'];
$ok = @mysql_query("DELETE FROM ads WHERE REFNUM='$ref");

if ($ok) {

echo("Advert Deleted");     

  } else {
  echo('<p>Error deleting from database!<br />'.
      'Error: ' . mysql_error() . '</p>');
}

?>

---

I go to delete it and it says deleted, yet when i check to see if it has deleted it hasn't

Help please?

also here is my table structure if it is any help

http://feudel.co.uk/images/advertise...d094f9saga.PNG

---

Are you looking to delete 1 reference number at a time or actually remove the RefNum table from the database?

PHP Code:

---

<?php
$hostname = "localhost"; 
$db_user = "*******"; // change to your database password
$db_password = "*******"; // change to your database password
$database = "*******"; // provide your database name
$db = mysql_connect($hostname, $db_user, $db_password);
mysql_select_db($database,$db);

$ref = $_GET['RefNum'];
$ok = @mysql_query("DELETE FROM `ads` WHERE `RefNum` = '$ref'");

if ($ok) {

echo("Advert Deleted");      

  } else {
  echo('<p>Error deleting from database!<br />'.
       'Error: ' . mysql_error() . '</p>');
}
mysql_close($db);
?>

---

thanks everyone, i got it working eventually :D