Drawing data out of database

Anon

Hey, here's my problem. I'm trying to get data out of a database from a specific area.
If your username and password equal this, then draw your data out.
So far my query is this:
SELECT Username, Rank, Money, Country from users WHERE Username='$Username' AND Password='$Password'

It hasn't been grabbing the variables or something because it shows Username, but not the other stuff.

Here's my script. Can you help me get this query right?

<?php
session_start();

print ("");
print ("<head></head>");
print ("<body bgcolor=\"#000000\" text=\"#ffffff\">");

require ("univvars.php");

if (mysql_connect($Host, $User, $Pass))
{
if (mysql_select_db($DBName, $Link))
{
$Query = "SELECT Username, Rank, Money, Country from users WHERE Username='$Username' AND Password='$Password'";

	$Result = mysql_query($Query);

	$num = mysql_num_rows($Result);

	if ($Submitted)
	{
		if ($num == 1)
		{	
				$Logged = TRUE;

				session_register('Rank');
				session_register('Username');
				session_register('Money');
				session_register('Country');
				session_register('Logged');

				print ("You are now logged in.  Go back to the mainpage via this link: <a href=\"index.php\">Main Page</a><br>$Country<br>$Money<br>$Rank");
		}
		else
		{
			print ("Invalid Username or Password.  Please try again!");	
		}
	}
	else
	{
		print ("<td><center><b>Login:</b><br>");
		print ("<tabe border=1 width=\"25%\"><form action=\"login.php\" method=POST>");
		print ("Username:<br>");
		print ("<input type=text name=\"Username\">");
		print ("<p>Password:<br>");
		print ("<input type=password name=\"Password\"><br>");
		print ("<input type=hidden name=\"Submitted\" value=\"TRUE\">");
		print ("<br><input type=Submit name=\"Submit\" value=\"Submit\"></td>");
	}
}

}
else
{
print ("Could not open page. Please try back later. If problem persists, contact webmaster at soldier_of_rome@hotmail.com.");
}
?>

Anon

Try using an array and the mysql_fetch_row() function, then call your variables with $myrow[0] ... $myrow[n].

Here is what I would try:

$Result = mysql_query($Query);

//create an array called $myrow to
//hold the multiple pieces of data
//from $result
$myrow = mysql_fetch_row($Result);

//load the data from the array
//into your variables
// notice the variables are indexed
// in the order you queried them
$Username = $myrow[0];
$Rank = $myrow[1];
$Money = $myrow[2];
$Country = $myrow[3];

//then just continue with your code
//and register the vars as normal

$num = mysql_num_rows($Result);

if ($Submitted)
{
if ($num == 1)
{
$Logged = TRUE;

session_register('Rank');
session_register('Username');
session_register('Money');
session_register('Country');
session_register('Logged');

===========================
PHP doesn't automatically pull data
from queries into variables, you have
to do it explicitly.

Hope this helps,
Phil M Price
pricepm@plu.edu