Jag håller på med en sida då man kan tippa resultat på diverse matcher, men scriptet som ska ge medlemmarna poäng när man godkänner en match buggar lite, koder är den här:
<?php
require '../inc/db.php';
// Choose the right table
$get = mysql_query("SELECT * FROM Tips WHERE Tips_GameID = '$Games_ID'");
$Scoren = "$Games_Score1-$Games_Score2";
$Tippen = "$userRow['Tips_Result1']-$userRow['Tips_Result2']";
// Count the posts
$rowCount = mysql_numrows($get);
// If there are no
if ($rowCount == 0)
{
echo "None tipped this game.";
}
else
{
while($userRow = mysql_fetch_array($get))
{
if ("$Scoren" == "2-0")
{
if ("$Tippen" == "2-0")
{
$update = "UPDATE Users SET Users_Points + 8 WHERE Users_UserName = '$userRow["Tips_UserName"]'";
$update2 = mysql_query($update) or die (mysql_error());
}
else
if ("$Tippen" == "2-1")
{
$update = "UPDATE Users SET Users_Points + 4 WHERE Users_UserName = '$userRow["Tips_UserName"]'";
$update2 = mysql_query($update) or die (mysql_error());
}
}
else
if ("$Scoren" == "0-2")
{
if ("$Tippen" == "0-2")
{
$update = "UPDATE Users SET Users_Points + 8 WHERE Users_UserName = '$userRow["Tips_UserName"]'";
$update2 = mysql_query($update) or die (mysql_error());
}
else
if ("$Tippen" == "1-2")
{
$update = "UPDATE Users SET Users_Points + 4 WHERE Users_UserName = '$userRow["Tips_UserName"]'";
$update2 = mysql_query($update) or die (mysql_error());
}
}
else
if ("$Scoren" == "2-1")
{
if ("$Tippen" == "2-1")
{
$update = "UPDATE Users SET Users_Points + 8 WHERE Users_UserName = '$userRow["Tips_UserName"]'";
$update2 = mysql_query($update) or die (mysql_error());
}
else
if ("$Tippen" == "2-0")
{
$update = "UPDATE Users SET Users_Points + 4 WHERE Users_UserName = '$userRow["Tips_UserName"]'";
$update2 = mysql_query($update) or die (mysql_error());
}
}
else
if ("$Scoren" == "1-2")
{
if ("$Tippen" == "1-2")
{
$update = "UPDATE Users SET Users_Points + 8 WHERE Users_UserName = '$userRow["Tips_UserName"]'";
$update2 = mysql_query($update) or die (mysql_error());
}
else
if ("$Tippen" == "0-2")
{
$update = "UPDATE Users SET Users_Points + 4 WHERE Users_UserName = '$userRow["Tips_UserName"]'";
$update2 = mysql_query($update) or die (mysql_error());
}
}
}
// Close database
mysql_close();
}
?>
och felmeddelandet:
Parse error: parse error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in c:\apache\htdocs\admin\games_report4.php on line 32