Very simple problem with my PHP code (help?)

I keep getting an error message (I guess) that says resource id #3

My echo statement does not output the desired $result

Help?

<?
if($_POST['submit']){

mysql_connect("*****************"); //Password and login removed for posting

mysql_select_db("orlandoi_referralowners") or die ('I cannot connect to the database because: ' .

mysql_error());


$Referrer=$_POST['ReferralID'];

$result = mysql_query("SELECT FirstName, LastName FROM owner_data WHERE OwnerID = '$Referrer'") or

die(mysql_error());




echo $result;

}
?>

What are you expecting it to echo? That is not an error message, you can pass that resource to mysql_fetch_assoc() (http://us3.php.net/mysql_fetch_assoc)
And work with your result set.

Good luck;

mysql_query() doesn't return immediately-echoable data; it returns a resource that contains your data. There are a number of functions to process this resource, such as mysql_fetch_array() (http://us3.php.net/manual/en/function.mysql-fetch-array.php) -- you have to run your $result variable through one of these functions before you can echo anything out of it.

Understood, sort of...

Here's what I changed it to, now I get nothing..

<?
if($_POST['submit']){

mysql_connect("*******************);
mysql_select_db("orlandoi_referralowners") or die ('I cannot connect to the database because: ' .

mysql_error());


$Referrer=$_POST['ReferralID'];

$result = mysql_query("SELECT FirstName AND LastName FROM owner_data WHERE OwnerID = '$Referrer'") or

die(mysql_error());


while ($row = mysql_fetch_assoc($result)) {
echo $row["FirstName"];
echo $row["LastName"];
}

}
?>

should be "FirstName, LastName" not "FirstName AND LastName"

It's always something like that, isn't it.. Thanks for all your help!

Here is a good tutorial
http://www.zend.com/php/beginners/php101-8.php#Heading5

I prefer the while($row = mysql_fetch_assoc($result)) method