[SOLVED] Extremely Newbie Question

[Keith121]

Please be kind...

 

I am writing a simple login script which will take the username and password information passed (via POST) from a form and compare them to information in a mysql database.

 

I am having trouble retrieving the information from the database. Here is my query:

 

$dbuser = mysql_query("SELECT * FROM profile WHERE login_id='$user'");

 

When a perform a var_dump I get this result:

 

resource(5) of type (mysql result)

 

How can I get the text string from my database so I can compare to what was entered in my initial form?

 

Thanks in advance!

 

[rhodesa]

mysql_query() returns a result resource. you then need to pull records from that result. in your case, there can only be one result:

$result = mysql_query("SELECT * FROM profile WHERE login_id='$user'") or die(mysql_error());
$dbuser = mysql_fetch_assoc($result);
print $dbuser['login_id'];

 

if your query had several records returned though, you would use a loop:

$result = mysql_query("SELECT * FROM profile") or die(mysql_error());
while($dbuser = mysql_fetch_assoc($result)){
  print $dbuser['login_id'];
}

[Keith121]

That did the trick!

 

Thanks for the help!!!