why is this not working?

[desjardins2010]

I'm getting error unknowing colum 'solidsoul' in Where clause

why is it refering $player = solidsoul to a colum instead of searching the colum username for solidsoul?

 

        <?php

	//start progress bar check to see if the systemkey on server is greater than the passwordcracker or equal if it is let it go if not stop it

	$db = mysql_connect ("localhost","removed","removed") or die ("Could Not Connect To Database");

	$select = mysql_select_db ('heaven_users') or die ("Could Not Select Database");

	$query = mysql_query ("SELECT systemkey FROM members WHERE IPaddress=$ip") or die (mysql_error());
	$query2 = mysql_query ("SELECT * FROM members WHERE username=$player") or die (mysql_error());

while ( ($row1 = mysql_fetch_assoc($query)) && ($row2 = mysql_fetch_assoc($query2)) ) {

	$systemkey = $row['systemkey'];
	$passwordcracker = $row2['passwordcracker'];


	}

echo $systemkey;
echo $passwordcracker;
	?>

[trq]

Strings need to be surrounded in quotes in most (all) programming languages including SQL.

[desjardins2010]

I don't see where I'm missing ""

[trq]

$query = mysql_query ("SELECT systemkey FROM members WHERE IPaddress='$ip'") or die (mysql_error());
$query2 = mysql_query ("SELECT * FROM members WHERE username='$player'") or die (mysql_error());

[trq]

You should also be getting that done in one query not two.

[desjardins2010]

lol how you do one query I thought I was doing well with the one while statment

[Rifts]

$onequery= mysql_query ("SELECT * FROM members WHERE IPaddress='$ip' AND username='$player' ") or die (mysql_error());