I have no idea why this is not working. I have the same file in other places and it works fine. But it won't check the user and pass and email on this one to let people into submit.php.
<?
include("dbconnect.php");
$username = $_POST["username"];
$password = $_POST["password"];
$email = $_POST["email"];
$result = MYSQL_QUERY("SELECT username, password, email from users WHERE
username='$username'and password='$password'and email='$email'")
or die ("Name and password not found or not matched");
$worked = mysql_fetch_array($result);
$username = $worked[username];
$password = $worked[password];
$email = $_POST["email"];
if($worked)
echo "
<form name=\"news\" method=\"post\" action=\"confirm.php\">
Welcome <B><i>" . $_POST['username'] . "</b></i>, please fill out this
form to submit a review:</p>
<table width=\"400\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">
<tr>
<td width=\"117\"><font size=\"1\">Title*: </font> </td>
<td width=\"577\">
<font size=\"1\">
<input type=\"text\" name=\"title\" size=\"50\" maxlength=\"35\">
</font>
</td>
</tr>
<tr>
<td width=\"117\"><font size=\"1\">Image URL for Poster*: </font> </td>
<td width=\"577\">
<font size=\"1\">
<input type=\"text\" name=\"poster\" size=\"50\">
</font>
</td>
</tr>
<tr>
<td width=\"117\"><font size=\"1\">Genre: </font> </td>
<td width=\"577\">
<font size=\"1\">
<input type=\"text\" name=\"genre\" size=\"50\" maxlength=\"35\">
</font>
</td>
</tr>
<tr>
<td width=\"117\"><font size=\"1\">Publisher: </font> </td>
<td width=\"577\">
<font size=\"1\">
<input type=\"text\" name=\"publisher\" size=\"50\" maxlength=\"35\">
</font>
</td>
</tr>
<tr>
<td width=\"117\"><font size=\"1\">Format: </font> </td>
<td width=\"577\">
<font size=\"1\">
<SELECT NAME=\"format\">
<OPTION VALUE=\"Movie\">Movie
<OPTION VALUE=\"OVA\">OVA
<OPTION VALUE=\"TV Series\">TV Series
</SELECT>
</font>
</td>
</tr>
<tr>
<td width=\"117\"><font size=\"1\">Year Released: </font> </td>
<td width=\"577\">
<font size=\"1\">
<input type=\"text\" name=\"released\" size=\"50\" maxlength=\"4\">
</SELECT>
</font>
</td>
</tr>
<tr>
<td width=\"117\"><font size=\"1\">Show Length: </font> </td>
<td width=\"577\">
<font size=\"1\">
<input type=\"text\" name=\"length\" size=\"50\" maxlength=\"20\">
</SELECT>
</font>
</td>
</tr>
<tr>
<td width=\"117\"><font size=\"1\">Content Rating: </font> </td>
<td width=\"577\">
<font size=\"1\">
<SELECT NAME=\"contentrating\">
<OPTION VALUE=\"G\">G
<OPTION VALUE=\"PG\">PG
<OPTION VALUE=\"PG-13\">PG-13
<OPTION VALUE=\"PG-14\">PG-14
<OPTION VALUE=\"R\">R
</SELECT>
</font>
</td>
</tr>
<tr>
<td width=\"117\"><font size=\"1\">Sound Rating: </font> </td>
<td width=\"577\">
<font size=\"1\">
<SELECT NAME=\"rsound\">
<OPTION VALUE=\"0\">0
<OPTION VALUE=\"0.5\">0.5
<OPTION VALUE=\"1\">1
<OPTION VALUE=\"1.5\">1.5
<OPTION VALUE=\"2\">2
<OPTION VALUE=\"2.5\">2.5
<OPTION VALUE=\"3\">3
<OPTION VALUE=\"3.5\">3.5
<OPTION VALUE=\"4\">4
<OPTION VALUE=\"4.5\">4.5
<OPTION VALUE=\"5\">5
</SELECT>
</font>
</td>
</tr>
<tr>
<td width=\"117\"><font size=\"1\">Lyrics Rating: </font> </td>
<td width=\"577\">
<font size=\"1\">
<SELECT NAME=\"rlyrics\">
<OPTION VALUE=\"0\">0
<OPTION VALUE=\"0.5\">0.5
<OPTION VALUE=\"1\">1
<OPTION VALUE=\"1.5\">1.5
<OPTION VALUE=\"2\">2
<OPTION VALUE=\"2.5\">2.5
<OPTION VALUE=\"3\">3
<OPTION VALUE=\"3.5\">3.5
<OPTION VALUE=\"4\">4
<OPTION VALUE=\"4.5\">4.5
<OPTION VALUE=\"5\">5
</SELECT>
</font>
</td>
</tr>
<tr>
<td width=\"117\"><font size=\"1\">Relation to Anime Rating: </font>
</td>
<td width=\"577\">
<font size=\"1\">
<SELECT NAME=\"rrelation\">
<OPTION VALUE=\"0\">0
<OPTION VALUE=\"0.5\">0.5
<OPTION VALUE=\"1\">1
<OPTION VALUE=\"1.5\">1.5
<OPTION VALUE=\"2\">2
<OPTION VALUE=\"2.5\">2.5
<OPTION VALUE=\"3\">3
<OPTION VALUE=\"3.5\">3.5
<OPTION VALUE=\"4\">4
<OPTION VALUE=\"4.5\">4.5
<OPTION VALUE=\"5\">5
</SELECT>
</font>
</td>
</tr>
<tr>
<td width=\"117\"><font size=\"1\">Impression Rating: </font> </td>
<td width=\"577\">
<font size=\"1\">
<SELECT NAME=\"rimmpression\">
<OPTION VALUE=\"0\">0
<OPTION VALUE=\"0.5\">0.5
<OPTION VALUE=\"1\">1
<OPTION VALUE=\"1.5\">1.5
<OPTION VALUE=\"2\">2
<OPTION VALUE=\"2.5\">2.5
<OPTION VALUE=\"3\">3
<OPTION VALUE=\"3.5\">3.5
<OPTION VALUE=\"4\">4
<OPTION VALUE=\"4.5\">4.5
<OPTION VALUE=\"5\">5
</SELECT>
</font>
</td>
</tr>
<tr>
<td width=\"117\"><font size=\"1\">Enjoyment Rating: </font> </td>
<td width=\"577\">
<font size=\"1\">
<SELECT NAME=\"renjoyment\">
<OPTION VALUE=\"0\">0
<OPTION VALUE=\"0.5\">0.5
<OPTION VALUE=\"1\">1
<OPTION VALUE=\"1.5\">1.5
<OPTION VALUE=\"2\">2
<OPTION VALUE=\"2.5\">2.5
<OPTION VALUE=\"3\">3
<OPTION VALUE=\"3.5\">3.5
<OPTION VALUE=\"4\">4
<OPTION VALUE=\"4.5\">4.5
<OPTION VALUE=\"5\">5
</SELECT>
</font>
</td>
</tr>
<tr>
<td width=\"117\"><font size=\"1\">Overall Rating:
<BR><B>For overall rating, pull out your calculator and average the
other ratings and round to the nearest number I got on the
list.</b></font> </td>
<td width=\"577\">
<font size=\"1\">
<SELECT NAME=\"roverall\">
<OPTION VALUE=\"0\">0
<OPTION VALUE=\"0.5\">0.5
<OPTION VALUE=\"1\">1
<OPTION VALUE=\"1.5\">1.5
<OPTION VALUE=\"2\">2
<OPTION VALUE=\"2.5\">2.5
<OPTION VALUE=\"3\">3
<OPTION VALUE=\"3.5\">3.5
<OPTION VALUE=\"4\">4
<OPTION VALUE=\"4.5\">4.5
<OPTION VALUE=\"5\">5
</SELECT>
</font>
</td>
</tr>
<tr>
<td width=\"117\"><font size=\"1\"></font></td>
<td width=\"577\">
<font size=\"1\">
<input type=\"hidden\" value=\"" . $_POST['username'] . "\"
name=\"user\" size=\"50\">
</font>
</td>
</tr>
<tr>
<td width=\"117\"><font size=\"1\">Review:</font></td>
<td width=\"577\">
<font size=\"1\">
<textarea name=\"review\" rows=10 cols=43></textarea>
</font>
</td>
</tr>
<tr>
<td width=\"117\"><font size=\"1\">Related Links:</font></td>
<td width=\"577\">
<font size=\"1\">
<input type=\"text\" name=\"links1\" size=\"50\" maxlength=\"35\">
<input type=\"text\" name=\"links2\" size=\"50\" maxlength=\"35\">
<input type=\"text\" name=\"links3\" size=\"50\" maxlength=\"35\">
<input type=\"text\" name=\"links4\" size=\"50\" maxlength=\"35\">
<input type=\"text\" name=\"links5\" size=\"50\" maxlength=\"35\">
</font>
</td>
</tr>
<tr><td width=\"500\">
<font size=\"1\">Track Name 1:<BR>
<input type=\"text\" name=\"trackname1\" size=\"50\" maxlength=\"35\">
<BR>
Track List 2:<BR>
<textarea name=\"tracklist1\" rows=10 cols=43></textarea>
<BR>
<font size=\"1\">Track Name 2:<BR>
<input type=\"text\" name=\"trackname2\" size=\"50\" maxlength=\"35\">
<BR>
Track List 2:<BR>
<textarea name=\"tracklist2\" rows=10 cols=43></textarea>
<BR>
<font size=\"1\">Track Name 3:<BR>
<input type=\"text\" name=\"trackname3\" size=\"50\" maxlength=\"35\">
<BR>
Track List 3:<BR>
<textarea name=\"tracklist3\" rows=10 cols=43></textarea>
<BR>
<font size=\"1\">Track Name 4:<BR>
<input type=\"text\" name=\"trackname4\" size=\"50\" maxlength=\"35\">
<BR>
Track List 4:<BR>
<textarea name=\"tracklist4\" rows=10 cols=43></textarea>
<BR>
</table>
<p>
<font size=\"1\">
<input type=\"submit\" name=\"Submit\" value=\"Submit\"></font>
</p>
</form>
<P><center>
MagiKreviews v0.1 Beta copyright Will Harrison.<BR>
MagiKreviews is made specifically for Anime Plug and is to be used no
where else.</center>
";
else {
echo("Login Incorrect, Please click back and try again");
}
?>
http://coa.valesk-interactive.com/news2/submit.php
http://coa.valesk-interactive.com/r4w6aw46a/submit.php if you wanna see what I mean.
