PHP encrypt problem

[simy202]

Hi everyone,
I am in trouble now. Just tried lots of different versions of AES_ENCRYPT / AES_DECRYPT scripts but cannot get it working. I've even tried putting the mySQL directly in via the phpAdmin query window where it works fine. I generated the following code from the 'generate php' button on there.

Can anybody tell me what I'm doing wrong, please.

The PHP encryption script is:

mysql_connect($dbhostname,$username,$password);
@mysql_select_db($database) or die( "databaseConnection=0");

$query = "INSERT INTO encodeit (id,card_number) VALUES (\'8\',AES_ENCRYPT(\'Anthony\',\'xk8\'))";

$successful = mysql_query($query);
echo $query;
echo $successful;
mysql_close();

This generates a record in my database, but the 'card_number' field is a blob so I can't view the data in there (unless someone can tell me otherwise???).

Thanks for any help in advance
Simy