Deleting a database entry, Help Please??

[craigtolputt]

Hi Guys,

 

I have a flash form that enters a users email address into a database which works fine but i need to have another form that deletes their email address so i thought it would be something like...

 

<?php

include "connect.php";

$tableName = "usersv2";

$email = $_POST['email'];

$insert = mysql_query("DELETE FROM $tableName (email) VALUES ('$email')";
$headers = "From: [email protected]\r\n";
$headers.= "Content-Type: text/html; charset=ISO-8859-1 ";
$headers .= "MIME-Version: 1.0 ";

$msg = "Thanks, your email address has been removed";

mail($email,"Thanks, your email address has been removed!",$msg,$headers);

echo "&msgText=Email Removed!";

?>

 

 

 

This doesnt seem to work though

 

any ideas??

[waynew]

include "connect.php";

$tableName = "usersv2";

$email = mysql_real_escape_string($_POST['email']);

$delete= mysql_query("DELETE FROM $tableName WHERE email = '$email'") or trigger_error(mysql_error());
  
if($delete== 1){
   $headers = "From: [email][email protected][/email] ";
   $headers.= "Content-Type: text/html; charset=ISO-8859-1 ";
   $headers .= "MIME-Version: 1.0 ";

   $msg = "Thanks, your email address has been removed";

   mail($email,"Thanks, your email address has been removed!",$msg,$headers);

   echo "&msgText=Email Removed!";
}

[craigtolputt]

Thanks,  thats done the trick...

 

Do you know if its possible to check a table in a database for new entries then if there are new entries to send them as an email to all the email address's in another table??

[cooldude832]

Store the date you last looked at it

 

and then when u go to look query Where DateEntered is >= Last Look Date

[craigtolputt]

What i thought was if i set a cron job up to run a php script once a week then the script can check a column in the news table like isNEW = 1 or something if it does equal 1 then the script will add it to an email and send that email out to my email address's in another table?

 

 

[cooldude832]

if date added isn't in there and doesn't need to be that is a logical solution

 

 

However if you have dates use them becuse adding a field for something like that is bad practice when a better solution is there

[craigtolputt]

Ah, ok.

 

Sorry im not a PHP developer im a flash developer but need to try and get this done.

 

So in the news table there are the following fields...

 

newsid

catalogid

title

content

picture

viewnum

adddate

rating

ratenum

source

sourceurl

isdisplay

 

[craigtolputt]

Then in another table i have

 

id

email

 

so i would like to run a script once a week which checks the adddate and then emails the news items for that week to the email address in the newsletter table.