Hulp With Delete Script

[Johnnikins]

Okay, i have a delete script which should work

<?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

[Trigs]

DELETE _ FROM

your missing whatever is in between DELETE and FROM

[Excellent]

Okay, i have a delete script which should work

<?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

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

[MrCraig]

<?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);
?>

[Johnnikins]

thanks everyone, i got it working eventually