PHP and MYsql: Trouble pulling data off the DB

I am trying to send a customer a conformation email. I can pull of all the customers shipping details (name, address etc) but when I try to get their email add to create the email. It only returns the value Resource ID #20. Can any one help??????

I'm guessing you've got a variable misnamed. When you see something like "Resource ID #20," it usually means you're printing the variable you assign mysql_connect() to. You really need to post the relevant code if you want specific help, though.

function email_order($valid_user)
{
$connection = db_connect();

if (!$connection )
{
echo "Failed to connect";
exit;
}

$query_get_order_detail = " select * from orders where userid = '$valid_user'";
$result = mysql_query($query_get_order_detail, $connection);

if (!$result)
{
echo "There is a problem, your order could not be mailed";
exit;
}

$result = @mysql_fetch_array($result);

if (!is_array($result))
{
echo "Not an array";
}
else
{

$query_email = "SELECT email FROM customers WHERE userid = '$valid_user'";
$email = mysql_query($query_email, $connection);
echo $email;
extract($result);
$subject = "Order Conformation";
$mailcontent = "User ID: ".$userid. "\n Order ID: ".$orderid."\n"
."Shipping Address line 1: ".$ship_add1."\n"
."Shipping Address line 2: ".$ship_add2."\n"
."Shipping Address line 3: ".$ship_add3."\n"
."Shipping Post Code: ".$ship_postcode."\n";
$fromaddress = "DVD Shack Order Conformation";
if (mail($email, $subject, $mailcontent, $fromaddress))
{
echo "An E-mail has been sent confirming your order";
}
else
{
echo "An email could not be sent";
}
}

}

Hope this helps.

Try the following inside your else statement