PHP and MySQL

[sylesia]

Ok, so I have a query that comes up with quite an odd response when I echo it.

<?
$conn = mysql_connect("localhost", "x", "xx");
mysql_select_db("evaluation", $conn);

$request = "SELECT EvaluatorName FROM yellowcard WHERE UserName = '$userName' AND CardNumber = '$cardNumber'";
$evalUser = mysql_query($request, $conn);
echo $evalUser;
?>

Now, I have echoed $userName, $cardNumber and both show up fine.  I have also run this query in MySQL and it comes up with the correct answer.  Yet when this runs in php, I get this
Resource id #4
Now, I am not sure what the issue is, I have tested every part, even doing CardNumber = $cardNumber since it is an integer value, but that is what it keeps echoing each time I try to use it.  Am I blind and missing something obvious, or what?

[onlyican]

yes, thats cos you are not calling the results

[code]
<?php
  $conn = mysql_connect("localhost", "x", "xx");
  mysql_select_db("evaluation", $conn);
 
  $request = "SELECT EvaluatorName FROM yellowcard WHERE UserName = '$userName' AND CardNumber = '$cardNumber'";
  $evalUser = mysql_query($request, $conn);

while($row = mysql_fetch_assoc($evalUser){
echo $row["fieldname"]."<br />\n";
}

?>
[/code]
Where fieldname is the name of the field in myself