Retrieving emails from database and replying using PHP

[vikela]

how can i retrieve and respond to emails in mysql db.i created a db for emails now i want to use php to retrieve mails 1 by 1 then responding or deleting the mails.help m new to php

[elflacodepr]

to retrieve your email you will need a query like this:

 

<?php
$sql = "SELECT * FROM emails ORDER BY subject ASC";
$query = mysql_query($sql);
				if (!$query) { // Handle error
					echo 'Query failed. SQL: ', $sql, '<br />Error # ', mysql_errno(), ' Error msg: ', mysql_error();
					exit;
					}

?>

 

Remember to change "emails" to your table name and "subject" to the column you want the query to be ordered.

[vikela]

i did put your code and nothing is coming out???it now looks like this:

 

$sql = "SELECT * FROM Email_Inb";// ORDER BY subject ASC";

$query = mysql_query($sql);

              if (!$query) { // Handle error

                  echo 'Query failed. SQL: ', $sql, '<br />Error # ', mysql_errno(), ' Error msg: ', mysql_error();

                  exit;

                  }

 

 

while($row=mysql_fetch_array($query)){

  echo "<br/ >Member ID:".$row['member_id']."<br /> Email Message:".$row['emailmsg']."<br />Received Date: ".$row['recdate']."<br />main ID:".$row['main_id']. "<br />";

  };

  ?>

 

 

I would also like to add a reply action on each mail i read or send it to a different table??

[fenway]

No errors? If you have php questions, post in the appropriate section.