auto email

[eluser]learning_php[/eluser]
Hi,

Sorry forgot to add this. it'a the form to decide to approve members or not:

Code:

<?PHP                                
$sql="select * FROM pending_members";
$Q = $this->db->query($sql);
foreach ($Q->result() as $row):?>
<table border="0">
     <tr>
         <td width="25px" nowrap="ON">&lt;?=$row->id?&gt;</td>
         <td width="150px" nowrap="ON" >&lt;?=$row->first_Name?&gt;</td>
         <td width="150px" nowrap="ON">&lt;?=$row->last_Name?&gt;</td>
         <td width="150px" nowrap="ON">&lt;?=$row->email?&gt;</td>
        <td width="150px" nowrap="ON">&lt;?=$row->username?&gt;</td>
        <td width="80px" nowrap="ON">&lt;?=$row->relationship?&gt;</td>
        
        &lt;?=form_open('homepage/updatemembers');?&gt;
        <td width="50px" nowrap="ON">
            <select name="approved">
            <option value=""></option>
              <option value="Yes">Yes</option>
              <option value="No">No</option>
              </select>
          </td>
          &lt;input type="hidden" name="id" value="&lt;?=$row-&gt;id?&gt;"/>
          &lt;input type="hidden" name="email" value="&lt;?=$row-&gt;email?&gt;"/>
        <td width="150px" >&lt;input type="submit" value="update"  /&gt;&lt;/td>
        
         &lt;?=form_close() ?&gt;
    </tr>
</table>
&lt;?PHP endforeach;?&gt;