1 reply to this topic

[bbqroast]

	$statData = mysql_query("SELECT * FROM `netstats` WHERE `player` = $profileIGN");

	if ($statData == false)	{

		echo 'This user has not been recorded yet :(';

	} else {

		$broken = mysql_result($statData, 0, 'broken');

		echo "This player has broken $broken blocks, <br>";

	}

Having connected to the database selected my database, and even run some other queries (which were successful) I run this code.
$statData is ALWAYS set to false!
If you really want me to I could post a picture of the database, I clearly see that $profileIGN has been set to bbqr0ast, and that a entry in the MySQL table is there.

I even tried changing the `player` part to ID and changing $profileIGN to 1, that worked fine...
I'm guessing MySQL doesn't like my string, anyone know why?

[Alexander]

Ah, the venerable string. Try this:

"SELECT * FROM `netstats` WHERE `player` = [B]'[/B]$profileIGN[B]'[/B]"

It is assumed to not be of a string constant if not in quotes, rather a macro function or other data type.

You could always test queries in mysql program, or PHPMyAdmin, or check mysql_error() for last returned error and it would likely throw a syntax issue.