Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    Regular Coder
    Join Date
    Mar 2006
    Posts
    459
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Managing My Email Table

    I have a table in my database called tblemail, basically it's 4 different types of emails that can be sent to my members. I am trying to create a page to display them but aren't having much luck... This is what I have come up with so far, it's more of the idea so hopefully someone understands what I am trying to do?

    PHP Code:
    <?php

    /* connect to the mysql database and use different queries for the count of members */

    include 'configure.php';
    include 
    'open.php';

    //navigation
    include("nav.php");

    $info mysql_query("SELECT * FROM tblEmail");

    echo 
    '<table border="1" cellpadding="3" cellspacing="1">
    <tr valign="top">
        <td>Email</td>
    </tr>
    <tr valign="top">
        <td>Details</td>
    </tr>
    <tr valign="top">
        <td>Is Active</td>
    </tr>
    <tr valign="top">
        <td></td>
    </tr>'
    ;

    (
    $qry mysql_fetch_array($info))

    //create the layout
    ?>
    <link href="cs_style.css" rel="stylesheet" type="text/css" />

    <tr valign="top">
    <td>
    <?php echo $qry['email_NM']; ?>
        <select name="select">
          <option>Please Select</option>
          <option value="A">Approved</option>
          <option value="R">Rejected</option>
          <option value="H">On Hold</option>
          <option value="P">Pending</option>
        </select>
    </td>
    </tr>

    <tr valign="top">
    <td>
        <?php echo $qry['email_body_TXT']; ?>
        <textarea name="textarea"></textarea>
    </td>
    </tr>

    <tr valign="top">
    <td>
        <?php echo $qry['active_FG']; ?>
        <select name="select">
          <option selected="selected">Please Select</option>
          <option value="1">Yes - Send Email</option>
          <option value="0">No - Don't Send Email</option>
        </select>
    </td>
    </tr>
    <tr valign="top">
    <td>
        <?php echo $qry['active_FG']; ?>
        <input type="submit" name="Submit" value="Update" />
    </td>
    </tr>
    <?php
       
    }
    }

    echo 
    '</table>';

    include 
    'library/closedb.php';

    ?>

  • #2
    Regular Coder
    Join Date
    Oct 2005
    Location
    Right Here
    Posts
    654
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Read up on while.


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •