I keep getting this error:
Parse error: parse error, unexpected T_STRING, expecting ',' or ';' in /home/coa/public_html/r4w6aw46a/submit.php on line 64
Here is my code:
<?
include("dbconnect.php");
$username = $_POST["username"];
$password = $_POST["password"];
$result = MYSQL_QUERY("SELECT * from users WHERE username='$username'and
password='$password'")
or die ("Name and password not found or not matched");
$worked = mysql_fetch_array($result);
$username = $worked[username];
$password = $worked[password];
if($worked)
echo "<html><head>
// The following code should be stored in the HTML head section
function disp_text()
{
var w = document.myform.mylist.selectedIndex;
var selected_text = document.myform.mylist.options[w].text;
alert(selected_text);
}
</head>
<form name=\"news\" method=\"post\" action=\"confirm.php\">
Welcome <B><i>" . $_POST['username'] . "</b></i>, please fill out this
form to submit news:</p>
<table width=\"100%\" 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\">
</font>
</td>
</tr>
<tr>
<td width=\"117\"><font size=\"1\">Poster URL*: </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\">
</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\">
</font>
</td>
</tr>
<tr>
<td width=\"117\"><font size=\"1\">Format: </font> </td>
<td width=\"577\">
<font size=\"1\">
<SELECT NAME="format">
<OPTION VALUE="f1">Movie
<OPTION VALUE="f2">OVA
<OPTION VALUE="f3">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\">
</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\">
</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="c1">G
<OPTION VALUE="c2">PG
<OPTION VALUE="c3">PG-13
<OPTION VALUE="c4">PG-14
<OPTION VALUE="c5">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="r0">0
<OPTION VALUE="r1">1
<OPTION VALUE="r2">2
<OPTION VALUE="r3">3
<OPTION VALUE="r4">4
<OPTION VALUE="r5">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="r0">0
<OPTION VALUE="r1">1
<OPTION VALUE="r2">2
<OPTION VALUE="r3">3
<OPTION VALUE="r4">4
<OPTION VALUE="r5">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="r0">0
<OPTION VALUE="r1">1
<OPTION VALUE="r2">2
<OPTION VALUE="r3">3
<OPTION VALUE="r4">4
<OPTION VALUE="r5">5
</SELECT>
</font>
</td>
</tr>
<tr>
<td width=\"117\"><font size=\"1\">Impression Rating: </font> </td>
<td width=\"577\">
<font size=\"1\">
<SELECT NAME="rimpression">
<OPTION VALUE="r0">0
<OPTION VALUE="r1">1
<OPTION VALUE="r2">2
<OPTION VALUE="r3">3
<OPTION VALUE="r4">4
<OPTION VALUE="r5">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="r0">0
<OPTION VALUE="r1">1
<OPTION VALUE="r2">2
<OPTION VALUE="r3">3
<OPTION VALUE="r4">4
<OPTION VALUE="r5">5
</SELECT>
</font>
</td>
</tr>
<tr>
<td width=\"117\"><font size=\"1\">Overall Rating: </font> </td>
<td width=\"577\">
<font size=\"1\">
<SELECT NAME="roverall">
<OPTION VALUE="r0">0
<OPTION VALUE="r1">1
<OPTION VALUE="r2">2
<OPTION VALUE="r3">3
<OPTION VALUE="r4">4
<OPTION VALUE="r5">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=\"100\">
<input type=\"text\" name=\"links2\" size=\"100\">
<input type=\"text\" name=\"links3\" size=\"100\">
<input type=\"text\" name=\"links4\" size=\"100\">
<input type=\"text\" name=\"links5\" size=\"100\">
</font>
</td>
</tr>
<table cellpadding=\"0\" cellspacing=\"0\" border=\"0\" width=\"100%\">
<tr><td width=\"25%\">
<B>Song name</td><td width=\"20%\">artist</td><td
width=\"20%\">album</td><td width=\"35%\">appearance
</td></tr></table>
<HR>
<table cellpadding=\"0\" cellspacing=\"0\" border=\"0\" width=\"100%\">
<tr><td width=\"25%\">
<B><input type=\"text\" name=\"song1\" size=\"50\"></td><td
width=\"20%\"><input type=\"text\" name=\"artist1\" size=\"50\"></td><td
width=\"20%\"><input type=\"text\" name=\"album1\" size=\"50\"></td><td
width=\"35%\"><input type=\"text\" name=\"appearance1\" size=\"50\">
</td></tr></table>
<BR>
<table cellpadding=\"0\" cellspacing=\"0\" border=\"0\" width=\"100%\">
<tr><td width=\"25%\">
<B><input type=\"text\" name=\"song2\" size=\"50\"></td><td
width=\"20%\"><input type=\"text\" name=\"artist2\" size=\"50\"></td><td
width=\"20%\"><input type=\"text\" name=\"album2\" size=\"50\"></td><td
width=\"35%\"><input type=\"text\" name=\"appearance2\" size=\"50\">
</td></tr></table>
<BR>
<table cellpadding=\"0\" cellspacing=\"0\" border=\"0\" width=\"100%\">
<tr><td width=\"25%\">
<B><input type=\"text\" name=\"song3\" size=\"50\"></td><td
width=\"20%\"><input type=\"text\" name=\"artist3\" size=\"50\"></td><td
width=\"20%\"><input type=\"text\" name=\"album3\" size=\"50\"></td><td
width=\"35%\"><input type=\"text\" name=\"appearance3\" size=\"50\">
</td></tr></table>
<BR>
<table cellpadding=\"0\" cellspacing=\"0\" border=\"0\" width=\"100%\">
<tr><td width=\"25%\">
<B><input type=\"text\" name=\"song4\" size=\"50\"></td><td
width=\"20%\"><input type=\"text\" name=\"artist4\" size=\"50\"></td><td
width=\"20%\"><input type=\"text\" name=\"album4\" size=\"50\"></td><td
width=\"35%\"><input type=\"text\" name=\"appearance4\" size=\"50\">
</td></tr></table>
<BR>
<table cellpadding=\"0\" cellspacing=\"0\" border=\"0\" width=\"100%\">
<tr><td width=\"25%\">
<B><input type=\"text\" name=\"song5\" size=\"50\"></td><td
width=\"20%\"><input type=\"text\" name=\"artist5\" size=\"50\"></td><td
width=\"20%\"><input type=\"text\" name=\"album5\" size=\"50\"></td><td
width=\"35%\"><input type=\"text\" name=\"appearance5\" size=\"50\">
</td></tr></table>
<BR>
<table cellpadding=\"0\" cellspacing=\"0\" border=\"0\" width=\"100%\">
<tr><td width=\"25%\">
<B><input type=\"text\" name=\"song6\" size=\"50\"></td><td
width=\"20%\"><input type=\"text\" name=\"artist6\" size=\"50\"></td><td
width=\"20%\"><input type=\"text\" name=\"album6\" size=\"50\"></td><td
width=\"35%\"><input type=\"text\" name=\"appearance6\" size=\"50\">
</td></tr></table>
<BR>
<table cellpadding=\"0\" cellspacing=\"0\" border=\"0\" width=\"100%\">
<tr><td width=\"25%\">
<B><input type=\"text\" name=\"song7\" size=\"50\"></td><td
width=\"20%\"><input type=\"text\" name=\"artist7\" size=\"50\"></td><td
width=\"20%\"><input type=\"text\" name=\"album7\" size=\"50\"></td><td
width=\"35%\"><input type=\"text\" name=\"appearance7\" size=\"50\">
</td></tr></table>
<BR>
<table cellpadding=\"0\" cellspacing=\"0\" border=\"0\" width=\"100%\">
<tr><td width=\"25%\">
<B><input type=\"text\" name=\"song8\" size=\"50\"></td><td
width=\"20%\"><input type=\"text\" name=\"artist8\" size=\"50\"></td><td
width=\"20%\"><input type=\"text\" name=\"album8\" size=\"50\"></td><td
width=\"35%\"><input type=\"text\" name=\"appearance8\" size=\"50\">
</td></tr></table>
<BR>
<table cellpadding=\"0\" cellspacing=\"0\" border=\"0\" width=\"100%\">
<tr><td width=\"25%\">
<B><input type=\"text\" name=\"song9\" size=\"50\"></td><td
width=\"20%\"><input type=\"text\" name=\"artist9\" size=\"50\"></td><td
width=\"20%\"><input type=\"text\" name=\"album9\" size=\"50\"></td><td
width=\"35%\"><input type=\"text\" name=\"appearance9\" size=\"50\">
</td></tr></table>
<BR>
<table cellpadding=\"0\" cellspacing=\"0\" border=\"0\" width=\"100%\">
<tr><td width=\"25%\">
<B><input type=\"text\" name=\"song10\" size=\"50\"></td><td
width=\"20%\"><input type=\"text\" name=\"artist10\"
size=\"50\"></td><td width=\"20%\"><input type=\"text\" name=\"album10\"
size=\"50\"></td><td width=\"35%\"><input type=\"text\"
name=\"appearance10\" size=\"50\">
</td></tr></table>
<BR>
</table>
<p>
<font size=\"1\">
<input type=\"submit\" name=\"Submit\" value=\"Submit\"></font>
</p>
</form>
<P>";
else {
echo("Login Incorrect, Please click back and try again");
}
?>
What is wrong?😕