Martin; I have taken your advice and read both of the articles, but
unfortunately I have not been able to find what needs to be changed.  As I
mentioned, I am very new at this.

Could you possibly look at the script and point me in the right direction?

Keep the faith




<title>Wireless Neighborhoods</title>
</head>  <?php
// Set the page title and include the HTML header.
$page_title = 'Wireless Neighborhoods';
include_once ('include/header.html');

$db_connection = mysql_connect ('', 'scfn',
'scfn75') or die (mysql_error());
$db_select = mysql_select_db('scfn') or die (mysql_error());
// If the form was submitted, process it.

if (isset($submit)) {
        $query = "insert into case_note values ('0', '$id',NOW(),
NOW(),'$cmanager', '$location', '$purpose', '$present', '$subject',
        if (@mysql_query ($query)) {
                echo 'A Case Note has been added.';
        } else {
                echo 'The case note could not be added.' . mysql_error();

<font face="Verdana">
<body bgcolor="#F0FFFD">

<p><font size="5">CTC Database Contact Log</font></p><?php
//Prints something like: Monday 15th of January 2003 05:51:38 AM
echo date("l dS of F Y -- h:i:s A");//Prints something like: Monday the 15th
<br><legend>Enter your information in the form below:</legend>
<form action="<?=$PHP_SELF ?>" method="post">

Client Name:<select name="id"><option>Select The Client</option>

// Select one of the Students.
$query = "SELECT id, CONCAT(fname, ', ', lname) AS name FROM client ORDER BY
lname ASC";
$query_result = @mysql_query ($query);
while ($row = @mysql_fetch_array ($query_result)) {
        echo "<option value=\"$row[id]\">$row[name]</option>\n";
</select> <br><br>

Contact Date: <input type="text" name="date_added"

Case Manager: <select name="cmanager"><option>Select a Case Manager</option>
        <option>Freddie Boykin</option>
        <option>Monica Harmon</option>
        <option>Ed Rivers</option>
        <option>Joseph McLeod</option>
    <option>Chasity Cheatham</option>
        <option>Rick Flanagan</option>
</select><br />
        <p>Purpose of Contact: <select size="1" name="purpose">
        <option>Select One</option>
        <option>Initial Contact</option>
        <option>Follow-up Contact</option>
        Location of Contact:&nbsp; <select size="1" name="location">
        <option>Select One</option>
        <option>Office Visit</option>
        <option>School Visit</option>
        <option>Home Visit</option>
        <option>Neighborhood Visit</option>
        <p>Present at Contact:&nbsp;&nbsp; <select size="1" name="present">
        <option>Select One</option>
        </select>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </p>
        <p>Subject:&nbsp; <input type="text" name="subject"
        <p>Notes:&nbsp;&nbsp;&nbsp; <textarea rows="4" name="note"
        <p><input type="submit" name="submit" value="Submit" /></p>
include_once ('include/footer.html');


PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to