Felmeddelande

PHP

1 svar · 185 visningar · startad av streetrobban

Medlem sedan jan. 20011 140 inlägg
Trådstart#1

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
Medlem sedan aug. 20002 975 inlägg
#2

Du måste kapsla in eller bryta ut array-variabler i en sträng.

$update = "UPDATE Users SET Users_Points + 4 WHERE Users_UserName = '{$userRow["Tips_UserName"]}'";
// eller
$update = "UPDATE Users SET Users_Points + 4 WHERE Users_UserName = '".$userRow["Tips_UserName"]."'";
265 ms totalt · 4 externa anrop · v20260731065814-full.d34c6d5a
126 ms — deklarationer (db)
0 ms — hämta statistik (cache)
132 ms — hämta tråd, inlägg och bilagor (db)
130 ms — ändringar (db)