Sorry..., my bad. Too wrapped up in the problem.
Notice: Undefined variable: row_rsID in
D:\web\hogana\demo\login\TMPbl2tw4o24u.php on line 48
Warning: Cannot add header information - headers already sent by (output
started at D:\web\hogana\demo\login\TMPbl2tw4o24u.php:48) in
D:\web\hogana\demo\login\TMPbl2tw4o24u.php on line 53
<?php require_once('../../Connections/connReg.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 = $HTTP_SERVER_VARS['PHP_SELF'];
if (isset($HTTP_SERVER_VARS['QUERY_STRING'])) {
$editFormAction .= "?" . $HTTP_SERVER_VARS['QUERY_STRING'];
}
if ((isset($HTTP_POST_VARS["MM_insert"])) &&
($HTTP_POST_VARS["MM_insert"] == "frmReg")) {
$insertSQL = sprintf("INSERT INTO user (username, fname, lname,
address, city, `state`, zip, phone, email) VALUES (%s, %s, %s, %s, %s,
%s, %s, %s, %s)",
GetSQLValueString($HTTP_POST_VARS['txtUserName'],
"text"),
GetSQLValueString($HTTP_POST_VARS['txtFName'],
"text"),
GetSQLValueString($HTTP_POST_VARS['txtLName'],
"text"),
GetSQLValueString($HTTP_POST_VARS['txtAddress'],
"text"),
GetSQLValueString($HTTP_POST_VARS['txtCity'],
"text"),
GetSQLValueString($HTTP_POST_VARS['txtState'],
"text"),
GetSQLValueString($HTTP_POST_VARS['txtZip'],
"text"),
GetSQLValueString($HTTP_POST_VARS['txtPhone'],
"text"),
GetSQLValueString($HTTP_POST_VARS['txtEmail'],
"text"));
mysql_select_db($database_connHoganMain, $connHoganMain);
$Result1 = mysql_query($insertSQL, $connHoganMain) or
die(mysql_error());
//Line 48 below -
$insertGoTo = "thanks.php?id=" . $row_rsID['userID'] . "";
if (isset($HTTP_SERVER_VARS['QUERY_STRING'])) {
$insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
$insertGoTo .= $HTTP_SERVER_VARS['QUERY_STRING'];
}
//Line 53 below -
header(sprintf("Location: %s", $insertGoTo));
}
mysql_select_db($database_connHoganMain, $connHoganMain);
$query_rsID = "SELECT * FROM `user`";
$rsID = mysql_query($query_rsID, $connHoganMain) or die(mysql_error());
$row_rsID = mysql_fetch_assoc($rsID);
$totalRows_rsID = mysql_num_rows($rsID);
?>
<html>
<head>
<title>User Registration</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<h1><strong><font size="6" face="Arial, Helvetica, sans-serif">Enter
Registration
Information </font></strong></h1>
<form action="<?php echo $editFormAction; ?>" method="POST"
name="frmReg" id="frmReg">
<p><font size="2" face="Arial, Helvetica, sans-serif">You must fill in
all the
required fields.</font></p>
<table width="51%" border="1">
<tr>
<td width="29%" bgcolor="#CCCCCC"> <div
align="right"><strong><font size="2" face="Arial, Helvetica,
sans-serif">First
Name: </font></strong></div></td>
<td width="71%"><div align="left">
<input name="txtFName" type="text" id="txtFName" size="30"
maxlength="28">
</div></td>
</tr>
<tr>
<td bgcolor="#CCCCCC"> <div align="right"><strong><font size="2"
face="Arial, Helvetica, sans-serif">Last
Name: </font></strong></div></td>
<td><div align="left">
<input name="txtLName" type="text" id="txtLName" size="30"
maxlength="28">
</div></td>
</tr>
<tr>
<td bgcolor="#CCCCCC"> <div align="right"><strong><font size="2"
face="Arial, Helvetica, sans-serif">Address:
</font></strong></div></td>
<td><div align="left">
<input name="txtAddress" type="text" id="txtAddress" size="40"
maxlength="38">
</div></td>
</tr>
<tr>
<td bgcolor="#CCCCCC"> <div align="right"><strong><font size="2"
face="Arial, Helvetica, sans-serif">City:
</font></strong></div></td>
<td><div align="left">
<input name="txtCity" type="text" id="txtCity" size="25"
maxlength="23">
</div></td>
</tr>
<tr>
<td bgcolor="#CCCCCC"> <div align="right"><strong><font size="2"
face="Arial, Helvetica, sans-serif">State:
</font></strong></div></td>
<td><div align="left">
<input name="txtState" type="text" id="txtState" size="28"
maxlength="26">
</div></td>
</tr>
<tr>
<td bgcolor="#CCCCCC"> <div align="right"><strong><font size="2"
face="Arial, Helvetica, sans-serif">Zip:
</font></strong></div></td>
<td><div align="left">
<input name="txtZip" type="text" id="txtZip" size="12"
maxlength="10">
</div></td>
</tr>
<tr>
<td bgcolor="#CCCCCC"> <div align="right"><strong><font size="2"
face="Arial, Helvetica, sans-serif">Phone:
</font></strong></div></td>
<td><div align="left">
<input name="txtPhone" type="text" id="txtPhone" size="14"
maxlength="12">
</div></td>
</tr>
<tr>
<td bgcolor="#CCCCCC"><div align="right"><strong><font size="2"
face="Arial, Helvetica, sans-serif">UserName:</font></strong></div></td>
<td><input name="txtUserName" type="text" id="txtUserName"
size="27" maxlength="25"></td>
</tr>
<tr>
<td bgcolor="#CCCCCC"> <div align="right"><strong><font size="2"
face="Arial, Helvetica, sans-serif">eMail
Address: </font></strong></div></td>
<td><div align="left">
<input name="txtEmail" type="text" id="txtEmail" size="40"
maxlength="38">
</div></td>
</tr>
</table>
<br>
<input name="Submit" type="submit" id="Submit" value="Submit">
<input name="Reset" type="reset" id="Reset" value="Reset">
<input type="hidden" name="MM_insert" value="frmReg">
</form>
<p><br>
</p>
<p><strong><font size="3" face="Arial, Helvetica,
sans-serif"></font></strong>
</p>
<?php
mysql_free_result($rsID);
?>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
