Need help

[Ziamor]

So im following the tutorials on http://buildingbrowsergames.com/ and I'm having some issues. I have two functions and they do exactly what I want. However if I execute both of them I get some errors. Here is the code for the two functions:

<?php 
function getStat($statName,$userID)
{
require_once 'config.php';
$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');
mysql_select_db($dbname);
$query = sprintf("SELECT user_stat.user_statValue 
				FROM user_stat 
				INNER JOIN stats ON (user_stat.statID = stats.statID) 
				WHERE stats.statShortName = '%s' AND user_stat.userID = '%s'",
	mysql_real_escape_string($statName),
	mysql_real_escape_string($userID));
$result = mysql_query($query);
list($value) = mysql_fetch_row($result);
return $value;	
}
function setStat($statName,$userID,$statValue)
{
require_once 'config.php';
$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');
mysql_select_db($dbname);
$query = sprintf("UPDATE user_stat SET user_statValue = user_statValue + '%s' WHERE statID = (SELECT statID FROM stats WHERE statFullName = '%s' OR statShortName = '%s') AND userID = '%s'",
	mysql_real_escape_string($statValue),
	mysql_real_escape_string($statName),
	mysql_real_escape_string($statName),
	mysql_real_escape_string($userID));
$result = mysql_query($query);
}
?>

Now When I do the staments below in this order I get this error:

Warning: mysql_fetch_row() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\proto\stats.php on line 14

If I switch them around the getStat() works however the setStat() doesnt do anything.

setStat("ASRIF",$_SESSION['userID'],10);
echo "User '" .$_SESSION['username'] ."' your stat is " .getStat("ASRIF",$_SESSION['userID']);

[Mod-Jay]

Its a MySQL Error, Whats line 14?

[Ziamor]

Its a MySQL Error, Whats line 14?

 

line 14 is

list($value) = mysql_fetch_row($result);

 

which is part of the getStat() function which runs fine if only its used without setStat() anywhere in the code.

[Pikachu2000]

The error indicates the query failed and returned a boolean FALSE to mysql_fetch_row(). Have you echoed the query to make sure it holds the values you'd expect it to hold?