Description:
------------
in my php pages i am using aes_encrypt which works fine. The issue i am having is with aes_decrypt. I have been searching for days to try and resolve this problem but need more help. The following string in my php will not bring any results back at all. I know it does work because running it in mysql direct works.

simple sql string:
SELECT AES_DECRYPT(password, 'keyhere') FROM accounts where id = '11';


Reproduce code:
---------------
$sql = "SELECT userId, name, email, aes_decrypt(password,'keyhere'), country FROM accounts where id='". $_SESSION['member_ID'] ."'";

$result = mysql_query($sql);

if (!$result) {
    echo "Could not successfully run query ($sql) from DB: " . mysql_error();
    exit;
}

if (mysql_num_rows($result) == 0) {
    echo "No rows found, nothing to print so am exiting";
    exit;
}
	while ($row = mysql_fetch_array($result))

{
     echo $row["userId"];
     echo $row["name"];
     echo $row["email"];
	 echo $row["password"];
	 echo $row["country"];
}

mysql_free_result($result);
mysql_close($conn);

Expected result:
----------------
123456 john john@email.com 'password should be here' UK

Actual result:
--------------
123456johnjohn@email.comUK