webForumDet fria alternativet

Felmeddelande

PHP

1 svar · 182 visningar · startad av streetrobban

Medlem sedan jan. 20011 140 inlägg
Frågan#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"]."'";
270 ms totalt · 4 externa anrop · v20260731065814-full.2f471f9e
128 ms — deklarationer (db)
0 ms — hämta statistik (cache)
139 ms — hämta tråd, inlägg och bilagor (db)
121 ms — ändringar (db)