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
John
<html>
<head>
<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 ('db.wireless-neighborhoods.org', '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',
'$note')";
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
?>
<fieldset>
<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>
<?php
// 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"
size="20">
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>
<option>Event</option>
</select>
Location of Contact: <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>
</select>
</p>
<p>Present at Contact: <select size="1" name="present">
<option>Select One</option>
<option>Client</option>
<option>Parent</option>
<option>Teachers</option>
</select> </p>
<p>Subject: <input type="text" name="subject"
size="69">
</p>
<p>Notes: <textarea rows="4" name="note"
cols="66"></textarea></p>
<p><input type="submit" name="submit" value="Submit" /></p>
</form>
<p> </p>
<?php
include_once ('include/footer.html');
?>
</body>
</html>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
