Page Load Blank

[Lynx Blade]

I've already made a post on this, but no one answered my question, or gave any
suggestions.

I build a page in dreamweaver, add in the insert record, and check new user
server behaviors, then save and upload to my remote site. When I go check it
on my site we my web browswer (IE) it loads blank. I have checked that it is
indeed on my remote site, I have double checked the connections for the db, and
have rebuilt the page multiple times.

Assuming I could be anything else I didn't mention there, wrong, what may be
causing this?

[rob::db]

Have you made sure you copied the database from your testing server to your
remote site as well as the site's files (if you were using a separate
testing server)?


Lynx Blade wrote:

> I've already made a post on this, but no one answered my question, or
> gave any suggestions.
>
> I build a page in dreamweaver, add in the insert record, and check
> new user server behaviors, then save and upload to my remote site.
> When I go check it on my site we my web browswer (IE) it loads blank.
> I have checked that it is indeed on my remote site, I have double
> checked the connections for the db, and have rebuilt the page
> multiple times.
>
> Assuming I could be anything else I didn't mention there, wrong,
> what may be causing this?

[Lynx Blade]

I"m not using a separate testing server, and it appears my testing server has all the same files my remote site does.

[rob::db]

I'm not talking about the files, I'm talking about the contents to the
database itself...


Lynx Blade wrote:

> I"m not using a separate testing server, and it appears my testing
> server has all the same files my remote site does.

[Lynx Blade]

Hum, we have reached something I do not have a clue about. How would I do such?

[rob::db]

Well, the database is rather fundamental to your project. That's the trouble
with software such as DW, they let you use something without understanding
it at all, so you can become a bit unstuck if there are any problems.

If you didn't set up a testing host on your local machine, and it sounds as
if you didn't, I doubt very much the problem is with missing data in the
database, as I should think that the database you were using for testing is
the same as the one you're running the main site off. And in that, case,
we'd really need to see your code...


Lynx Blade wrote:

> Hum, we have reached something I do not have a clue about. How
> would I do such?

[Lynx Blade]

yes i'm testing on the same one my site is on,
here is the code, and yes my connections file is uploaded on the remote and
testing server

<?php require_once('../Connections/MySQL.php'); ?>
<?php
// *** Redirect if username exists
$MM_flag="MM_insert";
if (isset($_POST[$MM_flag])) {
$MM_dupKeyRedirect="/arcadia/Ranking/ranking system.php";
$loginUsername = $_POST['username'];
$LoginRS__query = "SELECT username FROM userinfo WHERE username='" .
$loginUsername . "'";
mysql_select_db($database_MySQL, $MySQL);
$LoginRS=mysql_query($LoginRS__query, $MySQL) or die(mysql_error());
$loginFoundUser = mysql_num_rows($LoginRS);

//if there is a row in the database, the username was found - can not add
the requested username
if($loginFoundUser){
$MM_qsChar = "?";
//append the username to the redirect page
if (substr_count($MM_dupKeyRedirect,"?") >=1) $MM_qsChar = "&";
$MM_dupKeyRedirect = $MM_dupKeyRedirect . $MM_qsChar
.."requsername=".$loginUsername;
header ("Location: $MM_dupKeyRedirect");
exit;
}
}

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"] == "form1")) {
$insertSQL = sprintf("INSERT INTO userinfo (username, password, fullname,
accesslevel, age, gender, states, town, joined, lastadvancement, minorrank,
majorrank, blackstar, tacticallevel, honorables, disciple, mentor, events,
inbox, syal) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s,
%s, %s, %s, %s, %s, %s)",
GetSQLValueString($_POST['username'], "text"),
GetSQLValueString($_POST['password'], "text"),
GetSQLValueString($_POST['fullname'], "text"),
GetSQLValueString($_POST['accesslevel'], "text"),
GetSQLValueString($_POST['age'], "int"),
GetSQLValueString($_POST['gender'], "text"),
GetSQLValueString($_POST['states'], "text"),
GetSQLValueString($_POST['town'], "text"),
GetSQLValueString($_POST['joined'], "date"),
GetSQLValueString($_POST['lastadvancement'], "date"),
GetSQLValueString($_POST['minorrank'], "text"),
GetSQLValueString($_POST['majorrank'], "text"),
GetSQLValueString($_POST['blackstar'], "int"),
GetSQLValueString($_POST['tacticallevel'], "int"),
GetSQLValueString($_POST['honorables'], "int"),
GetSQLValueString($_POST['disciple'], "text"),
GetSQLValueString($_POST['mentor'], "text"),
GetSQLValueString($_POST['events'], "int"),
GetSQLValueString($_POST['inbox'], "int"),
GetSQLValueString($_POST['syal'], "int"));

mysql_select_db($database_MySQL, $MySQL);
$Result1 = mysql_query($insertSQL, $MySQL) or die(mysql_error());

$insertGoTo = "/arcadia/index.php";
if (isset($_SERVER['QUERY_STRING'])) {
$insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
$insertGoTo .= $_SERVER['QUERY_STRING'];
}
header(sprintf("Location: %s", $insertGoTo));
}
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>New User</title>
<script language="JavaScript" type="text/JavaScript">
<!--
function MM_findObj(n, d) { //v4.01
var p,i,x; if(!d) d=document;
if((p=n.indexOf("?"))>0&&parent.frames.length) {
d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++)
x=d.forms[i][n];
for(i=0;!x&&d.layers&&i<d.layers.length;i++)
x=MM_findObj(n,d.layers[i].document);
if(!x && d.getElementById) x=d.getElementById(n); return x;
}

function MM_validateForm() { //v4.0
var i,p,q,nm,test,num,min,max,errors='',args=MM_valida teForm.arguments;
for (i=0; i<(args.length-2); i+=3) { test=args[i+2]; val=MM_findObj(args[i]);
if (val) { nm=val.name; if ((val=val.value)!="") {
if (test.indexOf('isEmail')!=-1) { p=val.indexOf('@');
if (p<1 || p==(val.length-1)) errors+='- '+nm+' must contain an e-mail
address.\n';
} else if (test!='R') { num = parseFloat(val);
if (isNaN(val)) errors+='- '+nm+' must contain a number.\n';
if (test.indexOf('inRange') != -1) { p=test.indexOf(':');
min=test.substring(8,p); max=test.substring(p+1);
if (num<min || max<num) errors+='- '+nm+' must contain a number
between '+min+' and '+max+'.\n';
} } } else if (test.charAt(0) == 'R') errors += '- '+nm+' is required.\n';
}
} if (errors) alert('The following error(s) occurred:\n'+errors);
document.MM_returnValue = (errors == '');
}
//-->
</script>
</head>

<body
onLoad="MM_validateForm('username','','R','fullnam e','','R','age','','RinRange1:
150','town','','R','password','','R');return document.MM_returnValue">
<table width="800" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="150" bgcolor="#FFFFFF"><img
src="http://www.kervana.com/arcadia/Pictures/Layout/tsg1.png" width="800"
height="100"></td>
</tr>
<tr>
<td valign="top"><table width="800" border="0" cellspacing="0"
cellpadding="0">
<tr valign="top">
<td width="125" height="600" valign="top" bgcolor="#FFFFFF"><table
width="125" height="600" border="2" cellpadding="0" cellspacing="0">
<tr>
<td><object
classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000"
codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#ve
rsion=6,0,29,0" width="125" height="600">
<param name="movie"
value="/arcadia/Pictures/leftnavbar2.swf">
<param name="quality" value="high">
<embed src="/arcadia/Pictures/leftnavbar2.swf"
quality="high" pluginspage="http://www.macromedia.com/go/getflashplayer"
type="application/x-shockwave-flash" width="125" height="600"></embed>
</object></td>
</tr>
</table></td>
<td><table width="675" border="1" cellpadding="0" cellspacing="0"
bordercolor="#000000">
<tr>
<td height="50">&nbsp;</td>
</tr>
</table>

<table width="675" height="65" border="1" cellpadding="0"
cellspacing="0">
<tr>
<td>Add a new user account, all fields are required </td>
</tr>
</table>
<form action="<?php echo $editFormAction; ?>" method="POST"
enctype="multipart/form-data" name="form1">
<table width="675" height="900" border="1" cellpadding="0"
cellspacing="0">
<tr>
<td width="350">Username</td>
<td><input name="username" type="text" id="username"></td>
</tr>
<tr>
<td width="350">Password</td>
<td><input name="password" type="password" id="password"></td>
</tr>
<tr>
<td width="350">Fullname</td>
<td><input name="fullname" type="text" id="fullname"></td>
</tr>
<tr>
<td width="350">Age</td>
<td><input name="age" type="text" id="age" maxlength="3"></td>
</tr>
<tr>
<td width="350">Gender</td>
<td><select name="gender" id="gender">
<option>Select One Gender</option>
<option value="male">Male</option>
<option value="female">Female</option>
</select></td>
</tr>
<tr>
<td width="350">State</td>
<td><select name="states" id="states">
<option value="Alabama">Alabama</option>
<option value="Alaska">Alaska</option>
<option value="Arizona">Arizona</option>
<option value="Arkansas">Arkansas</option>
<option value="California">California</option>
<option value="Colorado">Colorado</option>
<option value="Connecticut">Connecticut</option>
<option value="Delaware">Delaware</option>
<option value="District of Columbia">District of
Columbia</option>
<option value="Florida">Florida</option>
<option value="Georgia">Georgia</option>
<option value="Hawaii">Hawaii</option>
<option value="Idaho">Idaho</option>
<option value="Illinois">Illinois</option>
<option value="Indiana">Indiana</option>
<option value="Iowa">Iowa</