[SOLVED] cant get variable to work. seems so simple.

[Reaper0167]

The username does not appear. What is going on? This should be simple.

 

<?php
include "connection.php";

$user_in = $_POST['pin_find'];
$user_email = $_POST['email_find'];
$to = $user_email;
$subject = 'Username Request';
$headers = 'From: [email protected]' ;

$sql = "SELECT username FROM members WHERE secret_code = '$user_in' AND email = '$user_email' LIMIT 1";
$result = mysql_query($sql);
$count=mysql_num_rows($result);
$name = $result;

$message = "Thank you for being a member.  Your username is'" . $name . "'  Please do not respond to this email.";

if($count == 1)
{
    if(mail($to, $subject, $message, $headers)) 
//if(mail($to, $subject, $message, "$headers"))
    {
        echo "Email sent";
    }
    else 
    {
        echo "Email not sent";
    }
}
?>

[vbnullchar]

s/b

 

$name = $result['username'];

[Philip]

s/b

 

$name = $result['username'];

 

As well as calling mysql_fetch_assoc

[Reaper0167]

thanks bud, i knew that, lol