I'm trying to get a default message displayed if someone doesn't enter a message. The field is an email field called "entryemail" and I want it to be optional. I made it optional and when someone doesn't enter anything I would like it to display "Not Provided" on the results page. Below is the code for the two pages I'm using for this form and results page.
This is the form page (addprayer.php):
<HTML>
<HEAD>
<TITLE>Prayer Request Entry</TITLE>
<script>
function ValidatePrayerRequest()
{
var name = document.PrayerRequest.entryname;
var email = document.PrayerRequest.entryemail;
var request = document.PrayerRequest.entryrequest;
if (name.value == "")
{
window.alert("Please enter your name.");
name.focus();
return false;
}
if (request.value.length < 10)
{
window.alert ("Please fill in your prayer request. (Min. 10 char.)");
request.focus();
return false;
}
return true;
}
</script>
</HEAD>
<body background="http://www.mttopmin.org/images/bkgnd_main.jpg" style="background-attachment: fixed;" bgproperties="fixed">
<?php
if ($HTTP_POST_VARS['submit']) {
mysql_connect("localhost","my_username","my_password");
mysql_select_db("ronparr_prayer");
$entryname=$HTTP_POST_VARS['entryname'];
$entryemail=$HTTP_POST_VARS['entryemail'];
$entryrequest=$HTTP_POST_VARS['entryrequest'];
$query ="INSERT INTO prayer (entryname,entryemail,entryrequest)";
$query.=" VALUES ('$entryname','$entryemail','$entryrequest')";
$result=mysql_query($query);
if ($result) echo "<b>Successfully Posted!</b>";
else echo "<b>ERROR: unable to post.</b>";
}
?>
<H1><center>Public Prayer Request</center></H1>
<p align="center"><b><a href="http://mttopmin.org/prayer/prayers.php">View Current Public Prayer Requests Here</a></b><br>
<b><a href="http://www.mttopmin.org/private_prayer_request_form.htm">Make Private Prayer Requests Here</a></b></p>
<HR>
<p><center><b>All public prayer requests will be displayed for <font color="red">3 days</font>. If you would like to have it displayed longer, please resubmit it after the 3rd day. All public prayer requests will be viewable to anyone on the internet. If you would like to request a private prayer, that only Pastor Ken will get,
please use the private prayer request page
<a href="http://www.mttopmin.org/private_prayer_request_form.htm">HERE</a>. Thank you.</b></center></p>
<HR>
<form method="POST" action="addprayer.php" name="PrayerRequest" onsubmit="return ValidatePrayerRequest();">
<b>Name:</b><br>
<input type="text" name="entryname" size=35><br>
<b>E-mail: </b>(optional)<br>
<input type="text" name="entryemail" size=35><br>
<b>Prayer Request:</b><br>
<textarea cols="60" rows="6" name="entryrequest">
</textarea><br>
<input type="submit" name="submit" value="Submit">
</form>
</BODY>
</HTML>
and here is the results page (prayers.php):
<html>
<head><title>Prayer Requests</title>
</head>
<body background="http://www.mttopmin.org/images/bkgnd_main.jpg" style="background-attachment: fixed;" bgproperties="fixed">
<h1><center>Public Prayer Requests</center></h1>
<p align="center"><b><a href="http://www.mttopmin.org/prayer/addprayer.php">Request a New Public Prayer Here</a></b>
<br><b><a href="http://www.mttopmin.org/private_prayer_request_form.htm">Request a New Private Prayer Here</a></b></p>
<hr>
<dl>
<?php
mysql_connect("localhost","my_username","my_password");
mysql_select_db("ronparr_prayer");
$query ="SELECT entryname, entryemail, entryrequest,";
$query.=" DATE_FORMAT(entrydate, '%M %d, %Y') AS date";
$query.=" FROM prayer WHERE DATE_SUB(CURDATE(),INTERVAL 3 DAY) <=entrydate ORDER BY entrydate DESC LIMIT 9999";
$result=mysql_query($query);
while (list($entryname,$entryemail,$entryrequest,$entrydate) =
mysql_fetch_row($result)) {
echo "<dt><b>Name: $entryname</b></dt>";
echo "<dt><b>Email: $entryemail</b></dt>";
echo "<dt><b>Submitted: $entrydate</b></dt>";
echo "<dt><b>Prayer Request:</b></dt>";
echo "<dd><font color=\"white\"><b>$entryrequest</b></font></dd><br><hr><br>";
}
mysql_close();
?>
</dl>
<p align="center"><b>No Current Prayer Requests? Check the <a href="http://www.mttopmin.org/prayer/prayers_archive.php">Archive</a> for Past Prayer Requests.</b></p>
</body>
</html>
I know this is an easy fix, but I have done searches and can't find the right code to enter or maybe the right place to put the code. I am still learning PHP and MySQL. Thanks to anyone who can help in advance.
