PHP - Mailing List-- Update ??

Hi guys,

I was just wondering if anyone could help me. I've got a My_SQL database containing articles, a summary for the article and a date. I have a basic CMS system set-up, but I want to create a script that when users sign up to a mail list it forwards the summary and dates of the articles database. If that makes sense? But I only want it to forward the most recent 5 rows. I'm pretty new to PHP and I've been mostly following tutorials thus far, but this is quite specific.

Thanks in advance!

Hi

I have been given a task to create some SQL reports.

One of the reports is to display all the customers who have purchased a certain product based on user selection and then have those results able to be extracted to a mailing list.

So ive got the report done. Some drop down boxes allow a user to select a product and once submitted the results are then displayed.

But i dont even know where to begin with extracting those results to a mailing list. Could someone help me please? What method should I use? and where do i begin? BTW im a rookie with PHP/Mysql ive just got my first job since leaving university and this is a task ive been given at work so any quick and helpful replies are greatly appreciated

Thanks in advance.

I need to update fields through a form, but there are MANY fields.

Instead of UPDATE table SET email='$email', name, etc, for EVERY value, is there a shortcut that might loop through all my fields, since I want every one of them to be checked for updated info.

Yesterday, I created a topic about how I could update records and I managed to achieve that successfully.

Now I have another dilemma.

When I have a specific record I want to update, I want to change a category ID of an product (e.g. change it from 1 to 2) but how do I go about doing this?

Here is my code thus far:

Code: [Select]
<?php

require_once ('./includes/config.inc.php');

require_once (MYSQL);

$id=$_GET['prodID'];

$results = mysqli_query($dbc, "SELECT * FROM product WHERE prodID=".$_GET['prodID']."");
$row = mysqli_fetch_assoc($results);

?>
<form action="" method='POST'>
Product ID: <input type="text" value="<?php echo $row['prodID'];?>" name="prodID" /> <br />
Product: <input type="text" value="<?php echo $row['product'] ;?>" name="product" /> <br />
Product Description: <input type="text" value="<?php echo $row['prod_descr'] ;?>" name="prod_descr" /> <br />
Category:
<select name="category">
<option value="<?php echo $row['catID'];?>"></option>
</select>
Price: <input type="text" value="<?php echo $row['price'] ;?>" name="price" /> <br />
In Stock: <input type="text" value="<?php echo $row['stock'] ;?>" name="stock" /> <br />
<br /><input type="submit" value="save" name="save">
</form>

<?php

if(isset($_POST['save']))
 {
    $id = $_POST['prodID'];
    $product = $_POST['product'];
$descr = $_POST['prod_descr'];
$price = $_POST['price'];
$stock = $_POST['stock'];

// Update data
    $update = mysqli_query($dbc, "UPDATE product SET product='$product', prod_descr='$descr', price='$price', stock='$stock' WHERE prodID=".$_GET['prodID']."");
header( 'Location: update_save.php' ) ;
}
?>

First off, hello.
This is my first pHp code, and still tying to get a grasp on it all. This is the pHp i have for my mailing form.
Now i wish to make the user have to put in a valid email address. Except it isn't working for me. The following script isn't coming up with any errors, but it is still letting the email field be submitted with any text.


<?php
  
  if ($_POST['submit'])
 
{

$name = $_POST['name'];
$email = $_POST['email'];
$comments = $_POST['comments'];

$errorstring = "";

if (!$name)
$errorstring = $errorstring."Name<br>";

if (!$email)
$errorstring = $errorstring."email<br>";

if (!$comments)
$errorstring = $errorstring."comments<br>";

if ($errorstring!="")
echo "You missed the following:<br>$errorstring";
else
{

$webMaster = "name@site.com";
$emailSubject = "Contact Us Form";
$mail_from = "$email";
 
$name = $_POST['name'];
$email = $_POST['email'];
$comments = $_POST['comments'];

function valid_email($email) {
   if(eregi("^[\w\-]+?\@\w+?\.\w+$", $email)) {
     return TRUE;
   } else {
     return FALSE;
   }
}

if (!valid_email($email)) {
   die('bad email');
}

$body = '
<br>
Name
' . $name . '
    <br><br>
Email
' . $email . '
<br><hr><br>
Comments<p>
' . $comments . '
';
 
$headers = "From: $email\r\n";
$headers .= "Content-type: text/html\r\n";
$success = mail($webMaster, $emailSubject, $body, $headers);


$redirect = file_get_contents('redirect.html');
echo $redirect;


}
}
  
?>


Thank you.

I'm trying to send an email that has a list created from a while loop to multiple people with an email list created from while loop.  Can someone please help me figure this out?  My brain is fried.  Here's the code that I have:

This is producing an error message that reads: Parse error: syntax error, unexpected '{' in /home/content/29/6879529/html/calhoun/admin/sendreport.php on line 22
Code: [Select]
<?php
include("conf.inc.php");

$result = mysql_query("SELECT `prefix`,`lname`,`email` FROM admin");
$row = mysql_fetch_row($result);

$result2 = mysql_query("SELECT `to`,`from`,`subject`,`message`,`date` FROM allmsgs WHERE reported = 'n' ORDER BY `messid` ASC");
$row2 = mysql_fetch_row($result2);

$cdate = date('m-d-Y');

while ($row = mysql_fetch_row($result)) {

$prefix = $row[0];
$lname = $row[1];
$adminemail = $row[2];
$fullname = "$prefix $lname";

$sendto = "$adminemail";
$emailsubject = "Webstats Report For $cdate.";

while ($row2 = mysql_fetch_row($result2){ // This is line 22.

$to = $row2[0];
$from = $row[1];
$subject = $row[2];
$message = $row[3];
$datetime = $row[4];

$eachmessage = "<p>
<hr width=\"400\">
To: $to<br>
From: $from<br>
On $datetime<br>&nbsp;<br>
$subject<br>$nbsp;<br>
$message
</p>";

}

$emailmessage = "<html>
<body>
$fullname,
<p>
Here is a list of the messages that have been exchanged in the last 24 hours.</p>
$eachmessage
</body>
</html>";

// To send HTML mail, the Content-type header must be set
$headers  = 'MIME-Version: 1.0' . "\r\n";
$headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";

// Additional headers

$headers .= 'From: Webstats <reports@webstats.com>' . "\r\n";

// Mail it
mail($sendto, $emailsubject, $emailmessage, $headers);

}

?>

Hi all,

I have a problem with emailing php code using a php function. using the code below, It emails the message 2 times with blank content. I think the problem might be with the eval() or file_get_content(), because if I comment it out the eval() and replace $message with a static value,  it sends the message once with the static content. The functions safeText (which does a mysql_real_escape_string), returnShopName (which returns the shop name) and returnShopEmailURL(which returns the url of the shop minus the http://www) all work, as they are used in other functions.

here is the function:
Code: [Select]
<?php
//Email a link to the voucher
function emailVoucher($id) {

//Ensure no one can use a combined URL and SQL Injection attack, as it comes from a $_GET
$id = safeText($id);

//Query the database, count the results and make an array to hold them
$query = mysql_query("SELECT * FROM shop_vouchers WHERE voucher_id = '".$id."' LIMIT 1") or die ('Error: '.mysql_error());
$count =  mysql_num_rows($query);
$fetch = mysql_fetch_array($query);

//If there are results
if($count == 1) {

$to = $fetch["voucher_email"];
$subject = 'Your voucher from '.returnShopName();
$headers = 'From: website@'. returnShopEmailURL() . "\r\n" . 'Reply-To: no-reply@'. returnShopEmailURL() . "\r\n" . 'X-Mailer: PHP/' . phpversion() . 'MIME-Version: 1.0' . "\r\n" . 'Content-type: text/html' . "\r\n";

$link = 'http://www.example.com/vouchers.php?email=1';
$name = returnShopName();
$URL = returnShopEmailURL();

$body = file_get_contents('includes/voucher_email.php');

eval("\$body = \"$message\";");

mail($to, $subject, $message, $headers);

gotoURL("vouchers.php?issue=1");

}else{

//Popup error message and redirect
echo '<script type="text/javascript">';
echo 'alert("An error occurred. Please try again.")';
echo '</script>';
gotoURL("vouchers.php");

}
}
?>
the code in voucher_email.php (for testing purposes) is:
Code: [Select]
$name 1, $link 2, $URL 3

Hi, PHP beginner here.   I'm trying to run a very basic script which does the following:   1) Input some data into a form 2) Outputs the data onto the screen 3) Click submit and e-mail it to me.   The purpose of it is simply to learn how to input some data, output that data along with some basic calculations and then to send that data to an e-mail address.   #1 & #2 I can do. I can enter some text and some numbers and on the next screen I can print a message containing the data I put into the form. Also I am taking the variables and doing some calculations which is fine.   However, when I click submit (on the second screen) to e-mail the data to me, I am getting an e-mail but none of the variables have retained the data.   FORM   <html>

Hey everyone I'm pretty new at PHP so i'm hoping someone can help me with this code. What I am trying to do is if someone selects a state say Kansas then fills out the rest of the form and clicks submit it will go to a specific email address. If someone selects another state like Nebraska it will go to a separate email address. Here is my code and I hope someone can help me with this.

PS I think I really screwed this one up lol :help:

Thanks,

B
Code: [Select]
<?php

/* Subject and Email variables */

 $emailSubject = 'Your Car Report Info.';
 $webMaster = 'me@rustyeckford.com';
 $webMaster2 ='me1@rustyeckford.com';
 $webMaster3 ='me2@rustyeckford.com';
 
 /* Gathering Data Variables */
 
 $f_nameField = $_POST['f_name'];
 $l_nameField = $_POST['l_name'];
 $addField = $_POST['Address'];
 $stateField = $_POST['state'];
 $phoneField = $_POST['phone'];
 $emailField = $_POST['email'];
 $vinField = $_POST['vin'];
 
 $body = <<<EOD
<br><hr><br>
First Name: $f_name <br>
Last Name: $l_name <br>
Address: $Address <br>
State: $state <br>
Phone: $phone <br>
Email: $email <br>
VIN: $vin <br>
EOD; 

switch($state) {
  case 'Kansas':
  case 'Oklahoma':
    $wm = $webMaster2;
    break;
  case 'Missouri':
  case 'Iowa':
    $wm = $webMaster3;
    break'
  case 'Nebraska:
    $wm = $webMaster;
    break;
}  

 $headers = "From: $email\r\n";
 $headers .= "Content-type: text/html\r\n";
 
$success = mail($wm, $emailSubject, $body, $headers);
 
 /* Results rendered from Html */
 
 $theResults = <<<EOD
<html>
<head>
<title>Your Car Report - Results</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">

body {
background-color: #f1f1f1;
font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: 12px;
font-style: normal;
line-height: normal;
font-weight: normal;
color: #666666;
text-decoration: none;
}

</style>
</head>

<div>
  <div align="center">Thank you for your submission. Your vehicle report will be provided to you very soon!</div>
</div>
</body>
</html>
EOD;



 echo "$theResults";
  
 
?>

I'm using 3 files to try and mass mail my members, massmail.php massmail-exe.php and elist.php

massmail.php

<form name="massmail" method="post" action="./massmail-exe.php">
<table width="450px">
<tr>
 <td valign="top">
  <label for="subject">Subject</label>
 </td>
 <td valign="top">
  <input type="text" name="subject" maxlength="50" size="30" id="subject">
 </td>
</tr>
<tr>
 <td valign="top">
  <label for="message">Email Content</label>
 </td>
 <td valign="top">
  <textarea  name="message" maxlength="9001" cols="100" rows="18" id="message"></textarea>
 </td>

</tr>
<tr>
 <td colspan="2" style="text-align:center">
  <input type="submit" value="Submit">
 </td>
</tr>
</table>
</form>


massmail-exe.php

<?php
// read the list of emails from the file.
$email_list = file("./elist.php");

// count how many emails there are.
$total_emails = count($email_list);

// go through the list and trim off the newline character.
for ($counter=0; $counter<$total_emails; $counter++) {
   $email_list[$counter] = trim($email_list[$counter]);
   }

// implode the list into a single variable, put commas in, apply as $to value.
$to = implode(",",$email_list);

if ( mail($to,$_POST["subject"],$_POST["message"]) ) {
   echo "The email has been sent!";
   } else {
   echo "The email has failed!";
   }
?>



and elist.php which has the email addresses.



What is wrong because every time i try and send it it say query failed.

Thanks so much.

Somebody please tell me why this wont work. Didnt wont to put my email in their.

<?php

$user = $_POST['subject'];
$email = $_POST['email'];
$message = $_POST['message'];

//To, Subject, Message
mailto(''); 
mailsubject('$user Sent you a message');
mailfrom('From: ' . $user . ' <' . $email . '>');

?>

what I am trying to do is use this php script to load the data being submitted in the html form into my database and then populate the database into an excel (xls) file and then e-mail it to my address.
 
Everything works great it populates into the database and creates the xls file perfect. But it is wanting me to download the file. What can I add to the script to have it e-mail the file to my e-mail address INSTEAD of downloading it.

Code: [Select]
<?php

define('DB_NAME', 'database');
define('DB_USER', 'username');
define('DB_PASSWORD', 'password');
define('DB_HOST', 'hostname');

$link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);
if (!$link)   
{
die('Could not connect: ' . mysql_error());  
}

$db_selected = mysql_select_db(DB_NAME, $link);

if (!$db_selected) {
die('Can\'t use ' . DB_NAME . ': ' . mysql_error());
}

$value1 = $_POST['groupname'];
$value2 = $_POST['name'];
$value3 = $_POST['address'];
$value4 = $_POST['city'];
$value5 = $_POST['state'];
$value6 = $_POST['zip'];
$value7 = $_POST['homephone'];
$value8 = $_POST['cellphone'];
$value9 = $_POST['email'];
$value10 = $_POST['age'];
$value11 = $_POST['maritalstatus'];
$value12 = $_POST['income'];
$value13 = $_POST['contact1'];
$value14 = $_POST['contact2'];
$value15 = $_POST['contact3'];
$value16 = $_POST['date1'];
$value17 = $_POST['date2'];
$value18 = $_POST['date3'];


$sql = "INSERT INTO clients (groupname, name, address, city, state, zip, homephone, cellphone, email, age, maritalstatus, income, contact1, contact2, contact3, date1, date2, date3) VALUES ('$value1', '$value2', '$value3', '$value4', '$value5', '$value6', '$value7', '$value8', '$value9', '$value10', '$value11', '$value12', '$value13', '$value14', '$value15', '$value16', '$value17', '$value18')";

if (!mysql_query($sql)) {
die('Error: ' . mysql_error());
}

mysql_close();

mysql_connect('hostname', 'username', 'password');
mysql_select_db('database');

$sql = "SELECT
`groupname` AS `Group`,
`name` AS `Customer Name`, 
`address` AS `Address`,
`city` AS `City`,
`state` AS `State`,
`zip` AS `Zip Code`,
`homephone` AS `Home Phone`,
`cellphone` AS `Cell Phone`,
`email` AS `E-Mail`,
`age` AS `Age Group`,
`maritalstatus` AS `Marital Status`,
`income` AS `Household Income`,
`contact1` AS `Contact VIA`,
`contact2` AS `Contact VIA`,
`contact3` AS `Contact VIA`,
`date1` AS `1st Date`,
`date2` AS `2nd Date`,
`date3` AS `3rd Date`

FROM fundtour_info.clients clients";

// Query Database
$result=mysql_query($sql);
$filename = 'file.xls';

// Send Header
header("Pragma: public");
header("Expires: 0");
header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
header("Content-Type: application/force-download");
header("Content-Type: application/octet-stream");
header("Content-Type: application/download");;
header("Content-Disposition: attachment;filename=$filename");
header("Content-Transfer-Encoding: binary ");

// XLS Data Cell

xlsBOF();   
xlsWriteLabel(0,0,"Group");
xlsWriteLabel(0,1,"Name");
xlsWriteLabel(0,2,"Address");
xlsWriteLabel(0,3,"City");
xlsWriteLabel(0,4,"State");
xlsWriteLabel(0,5,"Zip Code");
xlsWriteLabel(0,6,"Home Phone");
xlsWriteLabel(0,7,"Cell Phone");
xlsWriteLabel(0,8,"E-mail Address :");
xlsWriteLabel(0,9,"Age Group");
xlsWriteLabel(0,10,"Marital Status");
xlsWriteLabel(0,11,"Income");
xlsWriteLabel(0,12,"Contact Via");
xlsWriteLabel(0,13,"Dates");
   
$xlsRow = 1;
while(list($groupname,$name,$address,$city,$state,$zip,$homephone,$cellphone,$email,$age,$maritalstatus,$income,$contact1, $contact2, $contact3,$date1, $date3, $date3)=mysql_fetch_row($result)) 
{
++$i;
xlsWriteLabel($xlsRow,0,"$groupname");
xlsWriteLabel($xlsRow,1,"$name"); 
xlsWriteLabel($xlsRow,2,"$address");
xlsWriteLabel($xlsRow,3,"$city");
xlsWriteLabel($xlsRow,4,"$state");
xlsWriteLabel($xlsRow,5,"$zip");
xlsWriteLabel($xlsRow,6,"$homephone");
xlsWriteLabel($xlsRow,7,"$cellphone");
xlsWriteLabel($xlsRow,8,"$email");
xlsWriteLabel($xlsRow,9,"$age");
xlsWriteLabel($xlsRow,10,"$maritalstatus");
xlsWriteLabel($xlsRow,11,"$income");
xlsWriteLabel($xlsRow,12,"$contact1, $contact2, $contact3");
xlsWriteLabel($xlsRow,13,"$date1, $date3, $date3");                      
$xlsRow+++;
}
xlsEOF();
exit();

function xlsBOF() {
    echo pack("ssssss", 0x809, 0x8, 0x0, 0x10, 0x0, 0x0);  
    return;
}

function xlsEOF() {
    echo pack("ss", 0x0A, 0x00);
    return;
}

function xlsWriteNumber($Row, $Col, $Value) {
    echo pack("sssss", 0x203, 14, $Row, $Col, 0x0);
    echo pack("d", $Value);
    return;
}

function xlsWriteLabel($Row, $Col, $Value ) {
    $L = strlen($Value);
    echo pack("ssssss", 0x204, 8 + $L, $Row, $Col, 0x0, $L);
    echo $Value;
return;
} 

?>
Thanks for any help

Hey, been trying to make a form to upload an image to the server and also email the image as attachment. After nearly a week I managed to make it work. Only some validation needs to be done.

My next step is to make it work for multiple files, ie. 5. The form will have 5 boxes to upload images and no more. I have tried a few different things with for loops ( ie for $i=0; $i<5; $i++ {...} ) but no luck. I can't think of any solution of a loop to upload multiple files and then email multiple attachment as my code.

The code is:


<?php
session_start();
$imagename1 = $_FILES["uploadFile1"]["name"];
    $_SESSION['imagename1'] = $imagename1;

$imagename1 = $_SESSION['imagename1'];
$imagetype1 = $_SESSION['imagetype1'];
$imagesize1 = $_SESSION['imagesize1'];
$imagetemp1 = $_SESSION['imagetemp1'];


$thankyouurl = 'thankyou.php' ;
$errorurl = 'error.php' ;
$http_referrer = getenv( "HTTP_REFERER" );
$http_agent = getenv( "HTTP_USER_AGENT" );
$domain = $_SERVER['REMOTE_ADDR']; 
$filename = $_SESSION['uploadFilename'];



    if(isset($_POST['send'])) {
    
        $fp = fopen($imagetemp1, "rb");
        $file = fread($fp, $imagesize1);
        $file = chunk_split(base64_encode($file));
        $num = md5(time());
        fclose($fp);
        
    // UPLOAD FILE
    // possible PHP upload errors
    $errors = array(1 => 'php.ini max file size exceeded', 
                    2 => 'html form max file size exceeded', 
                    3 => 'file upload was only partial', 
                    4 => 'no file was attached');

    // check the upload form was actually submitted else print form
    isset($_POST['send'])
        or error('the upload form is neaded', $uploadForm);

    // check for standard uploading errors
    ($_FILES[$fieldname1]['error'] == 0)
        or error($errors[$_FILES[$fieldname1]['error']], $uploadForm);
    
    // check that the file we are working on really was an HTTP upload
    @is_uploaded_file($_FILES[$fieldname1]['tmp_name'])
        or error('not an HTTP upload', $uploadForm);
    
    // validation... since this is an image upload script we 
    // should run a check to make sure the upload is an image
    @getimagesize($_FILES[$fieldname1]['tmp_name'])
        or error('only image uploads are allowed', $uploadForm);
    
    // make a unique filename for the uploaded file and check it is 
    // not taken... if it is keep trying until we find a vacant one
    $now = date("y-m-d_H-i-s", time());
    
    while(file_exists($uploadFilename = $uploadsDirectory.$now.'_'.$_FILES[$fieldname1]['name']))
    {
        $now++;
    }

    // now let's move the file to its final and allocate it with the new filename
    @move_uploaded_file($_FILES[$fieldname1]['tmp_name'] , $uploadFilename)
        or error('receiving directory insuffiecient permission', $uploadForm);
    
        $from= 'youremail@server.co.uk'; 
        $emailTo = 'mail@hotmail.com';
        $subject = 'Quote Form'; 
        $body = "equipment_type: $equipment_type \n\nModel: $Model \n\nMake: $Make \n\nModelNumber: $ModelNumber";

        $fp = $_SESSION['fp'];
        $file = $_SESSION['file'];
        $num = "==Multipart_Boundary_x{$semi_rand}x".$_SESSION['num'];

        $headers = 'From: Name <'.$from.'>' . "\r\n" . 'Reply-To: ' . $emailTo;
        //Normal headers
        $headers  .= "MIME-Version: 1.0\r\n";
        $headers  .= "Content-Type: multipart/mixed; ";
        $headers  .= "boundary=".$num."\r\n";
        $headers  .= "--$num\r\n"; 
        // This two steps to help avoid spam    
        $headers .= "Message-ID: <".gettimeofday()." TheSystem@".$_SERVER['SERVER_NAME'].">\r\n";
        $headers .= "X-Mailer: PHP v".phpversion()."\r\n";         
        // With message
        $headers .= "Content-Type: text/html; charset=iso-8859-1\r\n";
        $headers .= "Content-Transfer-Encoding: 8bit\r\n";
        $headers .= "".$body."\n";
        $headers .= "--".$num."\n";  
        // Attachment headers
        $headers  .= "Content-Type:".$imagetype1." ";
        $headers  .= "name=\"".$imagename1."\"r\n";
        $headers  .= "Content-Transfer-Encoding: base64\r\n";
        $headers  .= "Content-Disposition: attachment; ";
        $headers  .= "filename=\"".$imagename1."\"\r\n\n";
        $headers  .= "".$file."\r\n";
        $headers  .= "--".$num."--";        
    
        mail($emailTo, $subject, $body, $headers);
        header( "Location: $thankyouurl" );
    }

?>


the form  is like this Code: [Select]
<input name="uploadFile1" id="uploadFile1" value="" class="file" type="file"/>can anyone suggest anything please?
how can I form the for statement?
much appreciated

Hi i have this simple update form and scrip but somehow it doesnt seem to be update the field on the database can someone help out please.
The html form is the second form bellow where the action send to status_update.php
HTML FORM
Code: [Select]
<?php                include("../header.html");            ?>
<?php                include("header_news.html");            
extract($_REQUEST,EXTR_SKIP);
?><?php            
/*                print("sfilm_refnum = $sfilm_refnum<BR>");                
print("sfilm_addr01 = $sfilm_addr01<BR>");                
print("sfilm_postcode = $sfilm_postcode<BR>");                
print("Film Client = $fclient<BR>");            */             
?>           
<form id="search" action="list.php" method="post" name="search">               
<table width="780" border="0" cellspacing="0" cellpadding="4" bgcolor="#eeeeee">                   
<tr>                       
<td align="right" width="140"></td>                       
<td width="320"><span class="hofblack10">                           
</span>                           
</td>                       
<td align="center" width="100"><input type="hidden" name="lstart" value="<?php print("$lstart"); ?>" /><input type="hidden" name="lend" value="<?php print("$lend"); ?>" /><input type="hidden" name="lamount" value="<?php print("$lamount"); ?>" /></td>                        <td align="center" width="100"></td>                       
<td align="right"></td>                   
</tr>               
</table>           
</form>           
<table width="780" border="0" cellspacing="0" cellpadding="4" bgcolor="#4050c4">               
<tr>                 
<td width="60" class="hofwhite10">action</td>                   
<td width="140"><span class="hofwhite14">DATE</span></td>                   
<td width="80"><span class="hofwhite14">ID</span></td>                   
<td><span class="hofwhite14">News Titile</span></td>                   
<td width="100"><span class="hofwhite14">Status</span></td>               
</tr>               
<tr height="0">                 
<td bgcolor="white" width="60"></td>                   
<td bgcolor="white" width="140" height="0"></td>                   
<td bgcolor="white" width="80" height="0"></td>                   
<td bgcolor="white" height="0"></td>                   
<td bgcolor="white" width="100" height="0"></td>               
</tr>           
</table><table width="780" border="0" cellspacing="0" cellpadding="4"><tr>                   
<td width="60"></td>                 
<td width="80"></td>                   
<td><a class="blueullrg" href="add.php">Add News</a></td>                   
<td align="right" width="120"></td>               
</tr>               
<tr height="0">                   
<td width="60" height="0"></td>                 
<td width="80" height="0"></td>                   
<td height="0"></td>                   
<td align="right" width="120" height="0"></td>               
</tr>           
</table>  <?php          
//get the DB connection variables    
include("../../../includes/config.php");        
//connect to DB        
$connection = @mysql_connect($db_address,$db_username,$db_password) or die("Couldn't CONNECT.");        
$db = @mysql_select_db($db_name, $connection) or die("Couldn't select DATABASE.");                
$query2="SELECT * FROM news WHERE !(news_status='deleted')";        
$result2 = mysql_query($query2) or die("Couldn't execute QUERY - Select NEWS Qty");        
$fqty = mysql_num_rows($result2);            
//SELECT or FIND the same USERNAME        
$query3="SELECT * FROM news WHERE !(news_status='deleted') ORDER BY news_id DESC";        
$result3 = mysql_query($query3) or die("Couldn't execute QUERY - Select NEWS");        
while ($row = mysql_fetch_array($result3))            
{                
$news_id                 = $row['news_id'];                
$news_title                = $row['news_title'];                
$news_story                = $row['news_story'];                
$news_image                = $row['news_image'];                
$news_image_caption        = $row['news_image_caption'];                
$news_image_link        = $row['news_image_link'];                
$news_date_day            = $row['news_date_day'];                
$news_date_month        = $row['news_date_month'];                
$news_date_year            = $row['news_date_year'];                
$news_status            = $row['news_status'];                
$news_website            = $row['news_website'];                
$news_date_created        = $row['news_date_created'];        
        $news_date_modified        = $row['news_date_modified'];    ?>           
        <table width="780" border="0" cellspacing="0" cellpadding="4" bgcolor="#eeeeee">               
        <tr>                 
        <td width="60"><span class="hofblack10">                   
         <?php                    
         if($news_status=="deleted"){                        
         print("<a class='hifblack10'>deleted</span>");                    
         }ELSE{                        
         print("<a class='blueul' href='edit.php?id=$news_id'>edit</a>");                    
         }                    
         ?>                 
          </span></td>                   
          <td width="140"><span class="titlegrey12">                     
          <?php                      
          if(!$news_date_day) 
          { echo "00"; }
          else{ echo $news_date_day; }                      
          echo "/";                     
           if(!$news_date_month) { echo "00"; }else{ echo $news_date_month; }                      
           echo "/";                      
           if(!$news_date_year) { echo "0000"; }else{ echo $news_date_year; }                    
           ?>                   
           </span></td>                   
           <td width="80"><span class="titlegrey12"><?php                    print("$news_id");                    ?></span>
           </td>                   
           <td><?php                    
           if($news_status=="deleted")
           {                        
           print("<class='hofblack10'>$news_title</span>");                    
           }ELSE{                        
           print("<a class='blueul' href='edit.php?id=$news_id'>$news_title</a>");                    
           }                    
           ?></td>                   
           <td width="100">                       
           <form id="list_update" action="status_update.php" method="post" name="list_update">                           
        <select name="newnstatus" size="1">                               
           <option  <?php if($row['news_status'] == "") 
           {
            print("selected");
           } ?>
           selected="selected" value="">Status...</option>                               
           <option  <?php if($row['news_status'] == "on")
           {
            print("selected");
           } ?> value="on">On</option>
               <option  <?php if($row['news_status'] == "off")
           {
            print("selected");
           } ?> value="off">Off</option>
            <option  <?php if($row['news_status'] == "deleted")
           {
            print("selected");
           } ?> value="deleted">Delete</option>
        </select>
         <input type="hidden" name="nstatus" value="<?php echo $row[news_status]; ?>" />                           
           <input type="hidden" name="id" value="<?php echo $row[news_id]; ?>" />                       
           <input type="submit" name="update" value="update" />                       
           </form>                     
            </td>               
            </tr>               
            <tr height="0">                 
            <td bgcolor="white" width="60"></td>                   
            <td bgcolor="white" width="140" height="0"></td>                   
            <td bgcolor="white" width="80" height="0"></td>                   
            <td bgcolor="white" height="0"></td>                   
            <td bgcolor="white" width="100" height="0"></td>               
            </tr>           
            </table>
            <?php            }        mysql_close($connection);//}?>           
            <table width="780" border="0" cellspacing="0" cellpadding="4">         
            <tr>                   
            <td width="60"></td>                 
            <td width="80"></td>                   
            <td><a class="blueullrg" href="add.php">Add News</a></td>                   
            <td align="right" width="120"></td>               
            </tr>           
            </table><?php                // include("list_navigation.html");            ?>
            <?php                include("../footer.html");            ?>
            </div></body></html>
The action script php
Code: [Select]
<?php
/*    echo "fstatus: ".$fstatus."<BR>";    
echo "id: ".$id."<BR>";    
echo "fclient: ".$fclient."<BR>";    
echo "newfstatus: ".$newfstatus."<BR>";*/    
//set the date of agreement        
$timestamp = date('l jS \of F Y h:i:s A');    
//get the DB connection variables        
include("../../../includes/config.php");
//connect to DB        
$connection = @mysql_connect($db_address,$db_username,$db_password) or die("Couldn't CONNECT.");        
$db = @mysql_select_db($db_name, $connection) or die("Couldn't select FILMS DATABASE.");    
// All appears well, so enter into database                
$query= "UPDATE news SET news_status = '$newnstatus' WHERE news_id='$id'";

$result = mysql_query($query) or die("could not execute query - Update FILMS Record to DB");    
//setup an email to the Admin @ hof, w/o attachment            
$emailto="xx@xxx.co.uk";        
$emailfrom="no-reply@xxxx.co.uk";        
$emailsubject="xx Record Updated";        
$emailmessage="Hello Registrar\n\n";        
$emailmessage.="News ID: ".$id."\n";        
$emailmessage.="Updated on: ".$timestamp."\n\n";        
$emailmessage.="Status was: ".$nstatus."\n";        
$emailmessage.="Status now: ".$newfnstatus."\n";        
$emailmessage.="Thank you,\n\n";        
$emailmessage.="Web Site ROBOT\n";        
$emailmessage.="(Administrator)\n";        
$emailmessage.="xxx.co.uk | xxx.biz\n";        
$emailmessage.="----------------------------------------------\n";        
$emailmessage.="e. http://www.xxx.co.uk/contact.php\n";        
$emailmessage.="w. http://www.xxx.co.uk\n";        
$emailheader="From: xxx.co.uk<$emailfrom>";
$emailheader  .= 'Cc: xxx@xxx.co.uk'."\r\n";
$emailheader  .= 'Bcc: xxx@xxxxx.co.uk'."\r\n";        
$ok=mail($emailto,$emailsubject,$emailmessage,$emailheader);        
mysql_close($connection);            
if ($ok)
 {        
 header("Location: list.php"); 
 /* Redirect browser */        
 exit;    
 } else {        
 $errmsg="There was a problem, please try later or telephone us direct.";        
 $errsta="1";        
 include("edit_error.html");        
 //echo "<p>Mail could not be sent. Sorry!</p>";        
 exit;    
 }        
 ?> Thanks in advance

Can anyone post a generic update function to update mysql table.
The manual approach:

update $tablename
set $column1='a', $column2='b'
where $id=$value;