PDA

View Full Version : Logging Date and IP address upon form submittal


Tech
04-09-2006, 01:02 AM
I'm new to DB integration with Dreamweaver. I've figured out how to create the form and have all of the fields store data into the DB. The problem I'm having is having the form send the IP address (REMOTE_ADDR) and the date (now()) into the DB when the form is submitted. Any help is greatly appreciated!

I'm using Dreamweaver MX 04, mysql, apache and GoDaddy for the hosting.

davidj
04-10-2006, 08:08 AM
if you have already sussed out how to do an update/insert into a db then adding these additional values isnt any more difficult

please post your code for what you have now..

Tech
04-10-2006, 12:59 PM
<?php require_once('Connections/AntiochDB.php'); ?>
<?php
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
$theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) : $theValue;

switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}

$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
$editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}

if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "requestFRM")) {
$insertSQL = sprintf("INSERT INTO PrayerRequests (Name, Email, Subject, Request, Public) VALUES (%s, %s, %s, %s, %s)",
GetSQLValueString($_POST['nameFLD'], "text"),
GetSQLValueString($_POST['emailFLD'], "text"),
GetSQLValueString($_POST['subjectFLD'], "text"),
GetSQLValueString($_POST['prayerFLD'], "text"),
GetSQLValueString($_POST['select'], "int"));

mysql_select_db($database_AntiochDB, $AntiochDB);
$Result1 = mysql_query($insertSQL, $AntiochDB) or die(mysql_error());

$insertGoTo = "updatedb.php";
if (isset($_SERVER['QUERY_STRING'])) {
$insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
$insertGoTo .= $_SERVER['QUERY_STRING'];
}
header(sprintf("Location: %s", $insertGoTo));
}
?>


I tried manually inserting the code but kept getting a javascript error. I figured I had to use Dreamweaver's wizards to make DW happy.

davidj
04-10-2006, 01:21 PM
Look at my example and compare with yours...

Make sure you check it and double check it then tripple check it.
count every var, %s, or it wont work

$insertSQL = sprintf("INSERT INTO PrayerRequests (Name, Email,
Subject, Request, Public, IP, Date1) VALUES (%s, %s, %s, %s, %s, %s, CURDATE())",
GetSQLValueString($_POST['nameFLD'], "text"),
GetSQLValueString($_POST['emailFLD'], "text"),
GetSQLValueString($_POST['subjectFLD'], "text"),
GetSQLValueString($_POST['prayerFLD'], "text"),
GetSQLValueString($_POST['select'], "int"),
$IP_var);

Tech
04-10-2006, 04:53 PM
Thanks for the quick reply!

Copied and pasted your code into the file. I get this error message when I click submit...

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ' CURDATE())' at line 2

TIA! :D

davidj
04-11-2006, 07:26 AM
post the code that you have

Tech
04-11-2006, 05:49 PM
<?php require_once('Connections/AntiochDB.php'); ?>
<?php
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
$theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) : $theValue;

switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}

$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
$editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}

if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "requestFRM")) {
$insertSQL = sprintf("INSERT INTO PrayerRequests (Name, Email,
Subject, Request, Public, IP, Date1) VALUES (%s, %s, %s, %s, %s, %s, CURDATE())",
GetSQLValueString($_POST['nameFLD'], "text"),
GetSQLValueString($_POST['emailFLD'], "text"),
GetSQLValueString($_POST['subjectFLD'], "text"),
GetSQLValueString($_POST['prayerFLD'], "text"),
GetSQLValueString($_POST['select'], "int"),
$IP_var);

mysql_select_db($database_AntiochDB, $AntiochDB);
$Result1 = mysql_query($insertSQL, $AntiochDB) or die(mysql_error());

$insertGoTo = "index.php";
if (isset($_SERVER['QUERY_STRING'])) {
$insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
$insertGoTo .= $_SERVER['QUERY_STRING'];
}
header(sprintf("Location: %s", $insertGoTo));
}


Thanks again!

davidj
04-12-2006, 07:49 AM
ok

i have rewritten it from DW shite code to bling dj code...

This is the bit i have re-written...

$nameFLD = $_POST['nameFLD'];
$emailFLD= $_POST['emailFLD'];
$subjectFLD= $_POST['subjectFLD'];
$prayerFLD= $_POST['prayerFLD'];
$select= $_POST['select'];
$IP_var = // IP Var function value

if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "requestFRM")) {
$insertSQL = sprintf("INSERT INTO PrayerRequests (Name, Email,
Subject, Request, Public, IP, Date1) VALUES (%s, %s, %s, %s, %s, %s, CURDATE())", $nameFLD, $emailFLD, $subjectFLD, $prayerFLD, $select, $IP_var );

mysql_select_db($database_AntiochDB, $AntiochDB);
$Result1 = mysql_query($insertSQL, $AntiochDB) or die(mysql_error());

$insertGoTo = "index.php";
if (isset($_SERVER['QUERY_STRING'])) {
$insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
$insertGoTo .= $_SERVER['QUERY_STRING'];
}
header(sprintf("Location: %s", $insertGoTo));
}


this is it in place...

<?php require_once('Connections/AntiochDB.php'); ?>
<?php
$nameFLD = $_POST['nameFLD'];
$emailFLD= $_POST['emailFLD'];
$subjectFLD= $_POST['subjectFLD'];
$prayerFLD= $_POST['prayerFLD'];
$select= $_POST['select'];
$IP_var = '';////////////////// IP Var function value ///////////////////////

if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "requestFRM")) {
$insertSQL = sprintf("INSERT INTO PrayerRequests (Name, Email,
Subject, Request, Public, IP, Date1) VALUES (%s, %s, %s, %s, %s, %s, CURDATE())", $nameFLD, $emailFLD, $subjectFLD, $prayerFLD, $select, $IP_var );

mysql_select_db($database_AntiochDB, $AntiochDB);
$Result1 = mysql_query($insertSQL, $AntiochDB) or die(mysql_error());

$insertGoTo = "index.php";
if (isset($_SERVER['QUERY_STRING'])) {
$insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
$insertGoTo .= $_SERVER['QUERY_STRING'];
}
header(sprintf("Location: %s", $insertGoTo));
}?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">

<head>
<title>Antioch Baptist Church</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<link rel="stylesheet" href="/Images/antioch.css" type="text/css" />
<script language="JavaScript" type="text/javascript">
//--------------- LOCALIZEABLE GLOBALS ---------------
var d=new Date();
var monthname=new Array("January","February","March","April","May","June","July","August","September","October","November","December");
//Ensure correct for language. English is "January 1, 2004"
var TODAY = monthname[d.getMonth()] + " " + d.getDate() + ", " + d.getFullYear();
//--------------- END LOCALIZEABLE ---------------
</script>
<style type="text/css">
<!--
body {
background-image: url();
}
.style5 {color: #D4D4D4}
-->
</style></head>
<body bgcolor="#F4FFE4">


</p>
<table width="775" height="0" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#F4FFE4">
<tr bgcolor="#3B6D96">
<td height="29" colspan="6"></td>
</tr>
<tr bgcolor="#99CC66">
<td height="10" colspan="6"></td>
</tr>

<tr bgcolor="#D5EDB3">
<td colspan="3" rowspan="2">/images/header.gif</td>
<td height="26" colspan="3" align="center" valign="bottom" bgcolor="#D5EDB3" class="subHeader" id="tagline">/images/abctag.gif</td>
</tr>
<tr bgcolor="#D5EDB3">
<td height="9" colspan="3" align="center" valign="top" bgcolor="#D5EDB3" class="subHeader" id="tagline">/images/abcsubtag.gif</td>
</tr>

<tr>
<td height="2" colspan="6" bgcolor="#5C743D">/Images/spacer.gif</td>
</tr>

<tr>
<td height="3" colspan="6" background="/Images/dashed_line.gif" bgcolor="#99CC66">/Images/dashed_line.gif</td>
</tr>

<tr bgcolor="#99CC66">
<td height="20" colspan="6" id="dateformat"><script language="JavaScript" type="text/javascript">
document.write(TODAY); </script> </td>
</tr>
<tr bgcolor="3B6D96">
<td height="3" colspan="6" background="/Images/dashed_line.gif">/Images/dashed_line.gif</td>
</tr>

<tr>
<td height="2" colspan="6" bgcolor="#5C743D">/Images/spacer.gif</td>
</tr>
<tr>
<td rowspan="4" bgcolor="3B6D96"><div align="center">/images/ABClogo.jpg </div>
</td>
<td height="56" colspan="5" align="left" valign="top"><div align="left">/images/collage.gif</div> </td>
</tr>
<tr>
<td height="19" colspan="5" align="left" valign="top"><table width="100%" height="5" border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<tr>
<td></td>
</tr>
</table></td>
</tr>
<tr>
<td height="36" colspan="5" align="left" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="5">

<tr>
<td width="20" class="pageName"></td>
<td class="pageName"><div align="left">PRAYER REQUEST </div></td>
</tr>

</table></td>
</tr>
<tr>
<td colspan="5" rowspan="2" align="left" valign="top">
<table width="100%" border="0" cellspacing="0" cellpadding="2">
<form action="<?php echo $editFormAction; ?>" name="requestFRM" id="requestFRM" method="POST">
<tr>
<td width="30" rowspan="4"></td>
<td width="97"><p style="font-weight: bold">Name:</p>
</td>
<td><input name="nameFLD" type="text" id="nameFLD" value="" size="20" maxlength="20" />

</td>
<td width="30" rowspan="4"> </td>
</tr>
<tr>
<td width="97"><span style="font-weight: bold">Email Address:</span></td>
<td><input name="emailFLD" type="text" id="emailFLD" value="" size="30" maxlength="50" /></td>
</tr>
<tr>
<td width="97"><span style="font-weight: bold">Subject:</span></td>
<td><input name="subjectFLD" type="text" id="subjectFLD" value="" size="50" maxlength="75" />
<span style="font-style: italic">(max. 75 characters) </span></td>
</tr>
<tr>
<td colspan="2"><p style="font-weight: bold">Please enter your prayer below. <textarea name="prayerFLD" cols="80" rows="20" id="prayerFLD"></textarea>
</p>



<select name="select" size="1">
<option>Make this Prayer Private</option>
<option>Make the Prayer Public</option>
</select>
</p>



<input type="submit" name="Submit" value="Submit" />
</p>




</p></td>
</tr>
<input type="hidden" name="MM_insert" value="requestFRM">
</form>
</table>
</td>
</tr>

<tr>
<td width="165" valign="top" bgcolor="3B6D96">
<table border="0" cellspacing="0" cellpadding="0" width="165" id="navigation">
<tr>
<td width="165" valign="top"></td>
</tr>
<tr>
<td width="165">Home (index.html)</td>
</tr>
<tr>
<td>Our History (history.htm)</td>
</tr>
<tr>
<td>We Believe (webelieve.htm)</td>
</tr>
<tr>
<td>Event Calendar (calendar.html)</td>
</tr>
<tr>
<td>Request a Prayer (prayerrequest.php)</td>
</tr><tr>
<td width="165">Pastor's Comments (index.html)</td>
</tr>
<tr>
<td>Photo Gallery (gallery.htm)</td>
</tr>
<tr>
<td width="165">Contact Us (contact.htm)</td>
</tr></table>
<div align="center">


</div></td>
</tr>
<tr>
<td width="165" height="19" bgcolor="3B6D96"></td>
<td width="196" bgcolor="3B6D96"></td>
<td width="42" bgcolor="3B6D96"></td>
<td width="199" bgcolor="3B6D96"></td>
<td width="57" bgcolor="3B6D96"></td>
<td width="184" bgcolor="3B6D96"><table width="100%" border="0" cellspacing="0" cellpadding="5">
<tr>
<td><div align="right"><span class="style5">&copy; 2006 Antioch Baptist Church</span></div></td>
</tr>
</table></td>
</tr>
</table>
</body>
</html>

Tech
04-12-2006, 01:30 PM
Hmm... no dice. It seems my CSS isn't working with this file anymore. When I submit the form, I get this...

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '@email.com, subject, 824, Make the Prayer Public, , CURDATE())'


[code]<?php require_once('Connections/AntiochDB.php'); ?>
<?php
$nameFLD = $_POST['nameFLD'];
$emailFLD= $_POST['emailFLD'];
$subjectFLD= $_POST['subjectFLD'];
$prayerFLD= $_POST['prayerFLD'];
$select= $_POST['select'];
$IP_var = '';////////////////// IP Var function value ///////////////////////

if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "requestFRM")) {
$insertSQL = sprintf("INSERT INTO PrayerRequests (Name, Email,
Subject, Request, Public, IP, Date1) VALUES (%s, %s, %s, %s, %s, %s, CURDATE())", $nameFLD, $emailFLD, $subjectFLD, $prayerFLD, $select, $IP_var );

mysql_select_db($database_AntiochDB, $AntiochDB);
$Result1 = mysql_query($insertSQL, $AntiochDB) or die(mysql_error());

$insertGoTo = "index.php";
if (isset($_SERVER['QUERY_STRING'])) {
$insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
$insertGoTo .= $_SERVER['QUERY_STRING'];
}
header(sprintf("Location: %s", $insertGoTo));
}?>

edited by dj

davidj
04-12-2006, 03:12 PM
ok

echo your $insertSQL var to the page then post results

Tech
04-12-2006, 03:43 PM
I hate to ask but could you show me exactly what/where to insert that? I know very very little about php. All of the php in that file was built by DW.

davidj
04-12-2006, 03:50 PM
add an echo here >> example

echo $insertSQL = sprintf("INSERT INTO PrayerRequests (Name, Email,
Subject, Request, Public, IP, Date1) VALUES (%s, %s, %s, %s, %s, %s, CURDATE())", $nameFLD, $emailFLD, $subjectFLD, $prayerFLD, $select, $IP_var );

please note that DW allows people to develop dynamic apps with little or no knowlege of code as long as you stick on the DW road. You are not allowed to turn off in any direction

as long as this is the journey you want to travel in then thats fine but what do you do when you get bored with the view? I am afraid you have to roll up your sleeves and get stuck into the code...

Tech
04-12-2006, 03:56 PM
I was hoping that I could stick to DW. I had a good friend do the complete functionality of the site through notepad but when I opened it in DW, it was all over the place. Since I'll be the one updating the site, I need it to work in DW, so that's why I came here. :D

INSERT INTO PrayerRequests (Name, Email, Subject, Request, Public, IP, Date) VALUES (jason, email@address.com, subject, Content, Make the Prayer Public, , CURDATE())You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '@address.com, subject, Content, Make the Prayer Public, , CURDA

<?php require_once('Connections/AntiochDB.php'); ?>
<?php
$nameFLD = $_POST['nameFLD'];
$emailFLD= $_POST['emailFLD'];
$subjectFLD= $_POST['subjectFLD'];
$prayerFLD= $_POST['prayerFLD'];
$select= $_POST['select'];
$IP_var = '';////////////////// IP Var function value ///////////////////////

if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "requestFRM")) {
echo $insertSQL = sprintf("INSERT INTO PrayerRequests (Name, Email,
Subject, Request, Public, IP, Date) VALUES (%s, %s, %s, %s, %s, %s, CURDATE())", $nameFLD, $emailFLD, $subjectFLD, $prayerFLD, $select, $IP_var );

mysql_select_db($database_AntiochDB, $AntiochDB);
$Result1 = mysql_query($insertSQL, $AntiochDB) or die(mysql_error());

$insertGoTo = "index.php";
if (isset($_SERVER['QUERY_STRING'])) {
$insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
$insertGoTo .= $_SERVER['QUERY_STRING'];
}
header(sprintf("Location: %s", $insertGoTo));
}?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">

<head>
<title>Antioch Baptist Church</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<link rel="stylesheet" href="/Images/antioch.css" type="text/css" />
<script language="JavaScript" type="text/javascript">
//--------------- LOCALIZEABLE GLOBALS ---------------
var d=new Date();
var monthname=new Array("January","February","March","April","May","June","July","August","September","October","November","December");
//Ensure correct for language. English is "January 1, 2004"
var TODAY = monthname[d.getMonth()] + " " + d.getDate() + ", " + d.getFullYear();
//--------------- END LOCALIZEABLE ---------------
</script>
<style type="text/css">
<!--
body {
background-image: url();
}
.style5 {color: #D4D4D4}
-->
</style></head>
<body bgcolor="#F4FFE4">


</p>
<table width="775" height="0" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#F4FFE4">
<tr bgcolor="#3B6D96">
<td height="29" colspan="6"></td>
</tr>
<tr bgcolor="#99CC66">
<td height="10" colspan="6"></td>
</tr>

<tr bgcolor="#D5EDB3">
<td colspan="3" rowspan="2">/images/header.gif</td>
<td height="26" colspan="3" align="center" valign="bottom" bgcolor="#D5EDB3" class="subHeader" id="tagline">/images/abctag.gif</td>
</tr>
<tr bgcolor="#D5EDB3">
<td height="9" colspan="3" align="center" valign="top" bgcolor="#D5EDB3" class="subHeader" id="tagline">/images/abcsubtag.gif</td>
</tr>

<tr>
<td height="2" colspan="6" bgcolor="#5C743D">/Images/spacer.gif</td>
</tr>

<tr>
<td height="3" colspan="6" background="/Images/dashed_line.gif" bgcolor="#99CC66">/Images/dashed_line.gif</td>
</tr>

<tr bgcolor="#99CC66">
<td height="20" colspan="6" id="dateformat"><script language="JavaScript" type="text/javascript">
document.write(TODAY); </script> </td>
</tr>
<tr bgcolor="3B6D96">
<td height="3" colspan="6" background="/Images/dashed_line.gif">/Images/dashed_line.gif</td>
</tr>

<tr>
<td height="2" colspan="6" bgcolor="#5C743D">/Images/spacer.gif</td>
</tr>
<tr>
<td rowspan="4" bgcolor="3B6D96"><div align="center">/images/ABClogo.jpg </div>
</td>
<td height="56" colspan="5" align="left" valign="top"><div align="left">/images/collage.gif</div> </td>
</tr>
<tr>
<td height="19" colspan="5" align="left" valign="top"><table width="100%" height="5" border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<tr>
<td></td>
</tr>
</table></td>
</tr>
<tr>
<td height="36" colspan="5" align="left" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="5">

<tr>
<td width="20" class="pageName"></td>
<td class="pageName"><div align="left">PRAYER REQUEST </div></td>
</tr>

</table></td>
</tr>
<tr>
<td colspan="5" rowspan="2" align="left" valign="top">
<table width="100%" border="0" cellspacing="0" cellpadding="2">
<form action="<?php echo $editFormAction; ?>" name="requestFRM" id="requestFRM" method="POST">
<tr>
<td width="30" rowspan="4"></td>
<td width="97"><p style="font-weight: bold">Name:</p>
</td>
<td><input name="nameFLD" type="text" id="nameFLD" value="" size="20" maxlength="20" />

</td>
<td width="30" rowspan="4"> </td>
</tr>
<tr>
<td width="97"><span style="font-weight: bold">Email Address:</span></td>
<td><input name="emailFLD" type="text" id="emailFLD" value="" size="30" maxlength="50" /></td>
</tr>
<tr>
<td width="97"><span style="font-weight: bold">Subject:</span></td>
<td><input name="subjectFLD" type="text" id="subjectFLD" value="" size="50" maxlength="75" />
<span style="font-style: italic">(max. 75 characters) </span></td>
</tr>
<tr>
<td colspan="2"><p style="font-weight: bold">Please enter your prayer below. <textarea name="prayerFLD" cols="80" rows="20" id="prayerFLD"></textarea>
</p>



<select name="select" size="1">
<option>Make this Prayer Private</option>
<option>Make the Prayer Public</option>
</select>
</p>



<input type="submit" name="Submit" value="Submit" />
</p>




</p></td>
</tr>
<input type="hidden" name="MM_insert" value="requestFRM">
</form>
</table>
</td>
</tr>

<tr>
<td width="165" valign="top" bgcolor="3B6D96">
<table border="0" cellspacing="0" cellpadding="0" width="165" id="navigation">
<tr>
<td width="165" valign="top"></td>
</tr>
<tr>
<td width="165">Home (index.html)</td>
</tr>
<tr>
<td>Our History (history.htm)</td>
</tr>
<tr>
<td>We Believe (webelieve.htm)</td>
</tr>
<tr>
<td>Event Calendar (calendar.html)</td>
</tr>
<tr>
<td>Request a Prayer (prayerrequest.php)</td>
</tr><tr>
<td width="165">Pastor's Comments (index.html)</td>
</tr>
<tr>
<td>Photo Gallery (gallery.htm)</td>
</tr>
<tr>
<td width="165">Contact Us (contact.htm)</td>
</tr></table>
<div align="center">


</div></td>
</tr>
<tr>
<td width="165" height="19" bgcolor="3B6D96"></td>
<td width="196" bgcolor="3B6D96"></td>
<td width="42" bgcolor="3B6D96"></td>
<td width="199" bgcolor="3B6D96"></td>
<td width="57" bgcolor="3B6D96"></td>
<td width="184" bgcolor="3B6D96"><table width="100%" border="0" cellspacing="0" cellpadding="5">
<tr>
<td><div align="right"><span class="style5">&copy; 2006 Antioch Baptist Church</span></div></td>
</tr>
</table></td>
</tr>
</table>
</body>
</html>

davidj
04-13-2006, 08:32 AM
you missunderstood

yes of course use dreamweaver but dont rely on the drag n drop code as much

anyways....

im not sure about this without it being on my own system. Your IP var is empty though

Tech
04-13-2006, 01:01 PM
Is there a way to log the IP address into a hidden field when the page is loaded?

I don't mind giving you FTP access to the site. There isn't anything on the site anybody would want. :)

Tech
04-17-2006, 05:39 PM
I appreciate all of your help DJ. Since you've worked on it so much, think somebody else might be able to alliviate DJ on this one?