Hi, I've been working on this code to access an SQL server, but for some reason I keep getting the "Parse error: parse error, unexpected ')', expecting ';'" error. I can't seem to find where I might have misplaced a ), I can't find anything wrong with the syntax, but obviously something is wrong. If anyone could provide a little objectivity that would be great. Thx 🙂
<html>
<head>
</head>
<body>
<?php
$username=mysql_escape_string($POST['username']);
$password=$POST['password'];
$repassword=$POST['retype'];
$email=mysql_escape_string($POST['email']);
/10/ $rulerName=$POST['title'];
$blank=" ";
$blank=$blank.$POST['gamename'];
$rulerName=$rulerName.$blank;
$rulerName=mysql_escape_string($rulerName);
$kingdomName=mysql_escape_string($_POST['kingdom']);
if ($password!=$repassword) {
echo("<script language='javascript'>
alert('Sorry, the two passwords you entered did not match. Please enter them again.')
/20/ parent.location.href='http://142.217.178.211'
</script>");
return;
}
$password=mysql_escape_string(md5($password));
$link=mysql_connect("142.217.178.211:3306")
or die("Could not connect: " . mysql_error());
$database=mysql_select_db("SpaceDB", $link)
/30/ or die("Database could not be selected: " . mysql_error());
$result=mysql_query("SELECT FROM userlist")
or die("Invalid Query: ".mysql_error());
$userresult=mysql_query("SELECT username FROM userlist")
or die("Invalid Query: ".mysql_error());
$passresult=mysql_query("SELECT password FROM userlist")
or die("Invalid Query: ".mysql_error());
$maxrows=mysql_num_rows($result);
$i=0;
for ($i,$i>=$maxrows,$i++) {
/40/ $gameuser=mysql_field_name($userresult, $i);
if ($username==$gameuser) {
echo("<script language='javascript'>
alert('Sorry, the username you have selected has already been taken. Please select another.')
parent.location.href='http://142.217.178.211'
</script>");
return;
}
}
$userquery=mysql_query("INSERT INTO userlist (username,password,email,rulername,kingdom) VALUES('$username','$password','$email','$rulerName','$kingdomName')")
/50/ or die("Invalid Query: " . mysql_error());
mysql_close($link);
?>
</body>
</html>
