PhpDig.net

Go Back   PhpDig.net > General Forums > Coding & Tutorials

Reply
 
Thread Tools
Old 11-02-2004, 12:16 PM   #1
hollycrj
Green Mole
 
Join Date: Feb 2004
Posts: 3
Form on our Intranet that will not email

We have this form on our Intranet that we use to update our rate sheets. We go into an admin site to change the rates then click on the submit button and the form is supposed to email the defined users with the new rate sheet. When I click on the submit button it gives me this message:

Notice: Undefined variable: result in C:\webs\SEWS\admin\rates\changerates.php on line 63

So when I go to the code and view this line number all I see is this:

if($result) {

All the code above this line is:

<?
if($name == "rate" && $pword == "changes") {

if(!isset($submit)) {
include 'connect.php';
$table="mortgage_rates";
$query = "select * from $table";
$queryresult = mssql_query($query);

while($row=mssql_fetch_array($queryresult)) {
$he80 = "$row[he80]";
$he90 = "$row[he90]";
$he100 = "$row[he100]";
$heloc80 = "$row[heloc80]";
$heloc90 = "$row[heloc90]";
$heloc100 = "$row[heloc100]";
$reslot = "$row[reslot]";
}
}
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<TITLE> SCU Intranet </TITLE>
<LINK REL=stylesheet HREF="/include/style.css" TYPE="text/css">
</HEAD>

<BODY>

<center>
Mortgage Loan Rates<br>

<? echo "<b>".date("F d,Y")."</b>"; ?><br><br>
<center>

<?
if(isset($submit)) {
$array = array('H/E 80%' => 'he80',
'H/E 90%' => 'he90',
'H/E 100%' => 'he100',
'HELOC 80' => 'heloc80',
'HELOC 90' => 'heloc90',
'HELOC 100' => 'heloc100',
'5 Year Residential Lot' => 'reslot');


while(list($k, $v) = each($array)) {
$i = 0;
if(empty($$v)) {
echo "<b>$k</b> is a required field.<br>";
$i++;
}
}

if($i != 0) {
echo "<b>Errors on the form prevent it from being submitted.</b>";
} else {
include 'connect.php';
$table="mortgage_rates";


I am so confused as to what all this means and how I need to fix this problem. We had someone that worked on our Intranet, but he is no longer with us. Any help you can provide would be greatly appreciated.
hollycrj is offline   Reply With Quote
Old 11-02-2004, 12:21 PM   #2
hollycrj
Green Mole
 
Join Date: Feb 2004
Posts: 3
Form on Intranet not emailing

We have this form on our Intranet that we use to update our rate sheets. We go into an admin site to change the rates then click on the submit button and the form is supposed to email the defined users with the new rate sheet. When I click on the submit button it gives me this message:

Notice: Undefined variable: result in C:\webs\SEWS\admin\rates\changerates.php on line 63

So when I go to the code and view this line number all I see is this:

if($result) {

All the code above this line is:

<?
if($name == "rate" && $pword == "changes") {

if(!isset($submit)) {
include 'connect.php';
$table="mortgage_rates";
$query = "select * from $table";
$queryresult = mssql_query($query);

while($row=mssql_fetch_array($queryresult)) {
$he80 = "$row[he80]";
$he90 = "$row[he90]";
$he100 = "$row[he100]";
$heloc80 = "$row[heloc80]";
$heloc90 = "$row[heloc90]";
$heloc100 = "$row[heloc100]";
$reslot = "$row[reslot]";
}
}
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<TITLE> SCU Intranet </TITLE>
<LINK REL=stylesheet HREF="/include/style.css" TYPE="text/css">
</HEAD>

<BODY>

<center>
Mortgage Loan Rates<br>

<? echo "<b>".date("F d,Y")."</b>"; ?><br><br>
<center>

<?
if(isset($submit)) {
$array = array('H/E 80%' => 'he80',
'H/E 90%' => 'he90',
'H/E 100%' => 'he100',
'HELOC 80' => 'heloc80',
'HELOC 90' => 'heloc90',
'HELOC 100' => 'heloc100',
'5 Year Residential Lot' => 'reslot');


while(list($k, $v) = each($array)) {
$i = 0;
if(empty($$v)) {
echo "<b>$k</b> is a required field.<br>";
$i++;
}
}

if($i != 0) {
echo "<b>Errors on the form prevent it from being submitted.</b>";
} else {
include 'connect.php';
$table="mortgage_rates";


I am so confused as to what all this means and how I need to fix this problem. We had someone that worked on our Intranet, but he is no longer with us. Any help you can provide would be greatly appreciated.
hollycrj is offline   Reply With Quote
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I crawl for email addresses on each website? shai200 How-to Forum 0 10-18-2006 10:01 AM
Use PhpDig in an Intranet ??? Vince How-to Forum 1 03-15-2005 10:01 AM
My Policy on PM/email Support vinyl-junkie The Mole Hole 0 10-09-2004 06:59 AM
email notification doesn't seem to work manute Feedback & News 3 10-12-2003 05:21 PM
email keyword report. jirving Mod Requests 1 09-29-2003 11:36 AM


All times are GMT -8. The time now is 08:23 PM.


Powered by vBulletin® Version 3.7.3
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Copyright © 2001 - 2005, ThinkDing LLC. All Rights Reserved.