ramboangel11

^^bump

I'd like to detect emails that hard bounce after i send out my newsletter, and then delete them from the table that stores them in my database. Any ideas? Thank you.

$sql = "DELETE FROM $table WHERE id = '$_POST[id]'";$result = mysql_query($sql, $connection) or die(mysql_error()); you need to define the name of the table you are deleting the user id from. then: WHERE id='$id' instead of the post id. Hopefully that works for you.

any ideas?

I'm not getting anything and I've added false emails to the email list. Also, they are coming from "anonymous" and not the email I put in the from field. $headers .= "From: [email protected]" . "\r\n"; $headers .= "Error-To: <" . "[email protected]" . ">\r\n"; $headers .= "Return-Path: <" . "[email protected]" . ">\r\n"; $headers = 'MIME-Version: 1.0' . "\r\n"; $headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";

I have a table in my database named newsletter, with a field named email. Is there a way in php to delete the row with email address field if the email is undeliverable to that email address because it no longer exists? Thank you in advance!

Thank you Fenway for your help. Pikachu2000, changing mysql_fetch_row to mysql_fetch_assoc fixed EVERYTHING! How come it's always one teeny tiny thing...You're awesome. Fantastic. You've made me ecstatic. haha. THANK YOU!

This is what I've tried with getting rid of $get_info: print "\t<td><font face=arial size=1/>{['name']}</font></td>\n"; print "\t<td><font face=arial size=1/>['name']</font></td>\n"; print "\t<td><font face=arial size=1/>$name</font></td>\n"; This is what my code looks like: $result = mysql_query( "SELECT name, price, thumbnail FROM s01_Products ORDER BY RAND() LIMIT 1" ) or die("SELECT Error: ".mysql_error()); $num_rows = mysql_num_rows($result); print "<table width=200 border=1>\n"; while ($get_info = mysql_fetch_row($result)){ print "<tr>\n"; print "\t<td><font face=arial size=1/>{$get_info['name']}</font></td>\n"; print "\t<td><font face=arial size=1/>{$get_info['price']}</font></td>\n"; print "\t<td><img src=\"{$get_info['thumbnail']}\"></td>\n"; print "</tr>\n"; } print "</table>\n"; Nothing is printing. The image shows up as broken. Phoo.

How come none of the information is printing out now? I got rid of the foreach statement, and have them printing separately as suggested by Pikachu.

graphics/00000001/toysandgames.jpg was the text displaying from the thumbnail field. and i was just thinking maybe the thumbnail field should be directed to a path? now it shows a broken image in that section, and the name and price are not printing at all. >.<

MySQL client version: 5.0.77 My code works fine. Displays what I want. However, I want to display the "thumbnail" field as an image, rather than text. I feel like my mind is too boggled from too many tutorials, and I feel like a rookie! The name and price should be displayed as text, which they are, and the thumbnail field is displaying the image filename, and I'd like it to display the image itself. Help, please? Thank you in advance! $result = mysql_query( "SELECT name, price, thumbnail FROM s01_Products ORDER BY RAND() LIMIT 1" ) or die("SELECT Error: ".mysql_error()); $num_rows = mysql_num_rows($result); print "<table width=200 border=1>\n"; while ($get_info = mysql_fetch_row($result)){ print "<tr>\n"; foreach ($get_info as $field) print "\t<td><font face=arial size=1/>$field</font></td>\n"; print "</tr>\n"; } print "</table>\n";