Thank you for your interest to help. I'm not sure how members post files here other than the feature below that allows me to attach a file but when I tried, a php extension is not permissible so I am pasting it here instead.
I'm not sure what you meant by "it could have started with values???? But I'm sure you guys might trace it somehow with my codes.
Thanks again
+++++++++++++++++++++++++++++++++++++++++++++++
<?php require_once('../Connections/exercise_member.php'); ?>
<?php require_once('../Connections/exercise_signup.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($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"] == "exercise_member")) {
$insertSQL = sprintf("INSERT INTO exercise_member (member_name1, member_name2, member_street, member_city, member_state, member_zip, member_phone) VALUES (%s, %s, %s, %s, %s, %s, %s)",
GetSQLValueString($_POST['member_name1'], "text"),
GetSQLValueString($_POST['member_name2'], "text"),
GetSQLValueString($_POST['member_street'], "text"),
GetSQLValueString($_POST['member_city'], "text"),
GetSQLValueString($_POST['member_state'], "text"),
GetSQLValueString($_POST['member_zip'], "int"),
GetSQLValueString($_POST['member_phone'], "text"));
mysql_select_db($database_exercise_member, $exercise_member);
$Result1 = mysql_query($insertSQL, $exercise_member) or die(mysql_error());
$insertGoTo = "exercise_result.php";
if (isset($_SERVER['QUERY_STRING'])) {
$insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
$insertGoTo .= $_SERVER['QUERY_STRING'];
}
header(sprintf("Location: %s", $insertGoTo));
}
if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "exercise_signup")) {
$insertSQL = sprintf("INSERT INTO exercise_signup (exercise_kind, exercise_bro, exercise_payment) VALUES (%s, %s, %s)",
GetSQLValueString($_POST['exercise_kind'], "text"),
GetSQLValueString($_POST['exercise_bro'], "text"),
GetSQLValueString($_POST['exercise_payment'], "text"));
mysql_select_db($database_exercise_signup, $exercise_signup);
$Result1 = mysql_query($insertSQL, $exercise_signup) or die(mysql_error());
$insertGoTo = "exercise_result.php";
if (isset($_SERVER['QUERY_STRING'])) {
$insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
$insertGoTo .= $_SERVER['QUERY_STRING'];
}
header(sprintf("Location: %s", $insertGoTo));
}
mysql_select_db($database_exercise_member, $exercise_member);
$query_rsexercise_member = "SELECT member_name1, member_name2, member_street, member_city, member_state, member_zip, member_phone FROM exercise_member";
$rsexercise_member = mysql_query($query_rsexercise_member, $exercise_member) or die(mysql_error());
$row_rsexercise_member = mysql_fetch_assoc($rsexercise_member);
$totalRows_rsexercise_member = mysql_num_rows($rsexercise_member);
mysql_select_db($database_exercise_signup, $exercise_signup);
$query_rsexercise_signup = "SELECT exercise_kind, exercise_bro, exercise_payment FROM exercise_signup";
$rsexercise_signup = mysql_query($query_rsexercise_signup, $exercise_signup) or die(mysql_error());
$row_rsexercise_signup = mysql_fetch_assoc($rsexercise_signup);
$totalRows_rsexercise_signup = mysql_num_rows($rsexercise_signup);
?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "
http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="
http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>Exercise Sign_Up</title>
<style type="text/css">
<!--
body {
background-color: #C9CDBD;
margin-left: 50px;
margin-top: 50px;
}
-->
</style></head>
<body>
<form name="exercise_member" action="<?php echo $editFormAction; ?>" method="POST" enctype="multipart/form-data" target="_blank" id="exercise_member">
<table width="700" border="0" cellspacing="5">
<tr>
<td width="76"><div align="right">First Name:</div></td>
<td width="605"><input name="member_name1" type="text" id="member_name1" value="<?php echo $row_rsexercise_member['member_name1']; ?>" size="40" maxlength="30" /></td>
</tr>
<tr>
<td><div align="right">Last Name:</div></td>
<td><input name="member_name2" type="text" id="member_name2" value="<?php echo $row_rsexercise_member['member_name2']; ?>" size="40" maxlength="40" /></td>
</tr>
<tr>
<td><div align="right">Address 1:</div></td>
<td><input name="member_street" type="text" id="member_street" value="<?php echo $row_rsexercise_member['member_street']; ?>" size="40" maxlength="60" /></td>
</tr>
<tr>
<td><div align="right">Address 2:</div></td>
<td><input name="member_city" type="text" id="member_city" value="<?php echo $row_rsexercise_member['member_city']; ?>" size="40" maxlength="30" /></td>
</tr>
<tr>
<td><div align="right">State:</div></td>
<td><input name="member_state" type="text" id="member_state" value="<?php echo $row_rsexercise_member['member_zip']; ?>" size="40" maxlength="2" /></td>
</tr>
<tr>
<td><div align="right">Zip:</div></td>
<td><input name="member_zip" type="text" id="member_zip" value="<?php echo $row_rsexercise_member['member_zip']; ?>" size="40" maxlength="5" /></td>
</tr>
<tr>
<td><div align="right">Phone:</div></td>
<td><input name="member_phone" type="text" id="member_phone" value="<?php echo $row_rsexercise_member['member_phone']; ?>" size="40" maxlength="14" /></td>
</tr>
</table>
<p> </p>
<p>
<label for="label">What kind of exercise are you looking for?</label>
<br />
<input name="exercise_kind2" type="text" id="label" value="<?php echo $row_rsexercise_signup['exercise_kind']; ?>" size="40" maxlength="40" />
</p>
<p>
<label for="label2">Would you like to receive a brochure for complete info?</label>
<br />
<input name="exercise_bro2" type="text" id="label2" value="<?php echo $row_rsexercise_signup['exercise_bro']; ?>" size="10" maxlength="10" />
</p>
<p>
<label for="label3">Would you like to pay online or at the store?</label>
<br />
<input name="exercise_payment2" type="text" id="label3" value="<?php echo $row_rsexercise_signup['exercise_payment']; ?>" size="30" maxlength="30" />
</p>
<p>
<label for="label4"></label>
<input type="submit" name="sign_up2" id="label4" value="Sign Up!" />
</p>
<p></p>
<p>
<input type="hidden" name="MM_insert" value="exercise_member" />
</p>
</form>
</body>
</html>
<?php
mysql_free_result($rsexercise_member);
mysql_free_result($rsexercise_signup);
?>