I need to extract last digit number from NAME From Mysql table Talbe_recipient, however it seems that script return nothing. Is there anyther wrong?
--------------------------------
$sql_syntax = qq(SELECT ID, recipID, NAME, RIGHT(NAME,1) AS age FROM $table_recipient WHERE ( Sender_ID ='$sender_ID') );
&SQL_EXE($dbh,$sql_syntax);
my( $ID, $recipID, $NAME, $age);
$sth->bind_columns( undef, \$ID, \$recipID, \$age);
print<<"[HTML]";
$age
[HTML]
-----------------------------
Thanks in advance
--------------------------------
$sql_syntax = qq(SELECT ID, recipID, NAME, RIGHT(NAME,1) AS age FROM $table_recipient WHERE ( Sender_ID ='$sender_ID') );
&SQL_EXE($dbh,$sql_syntax);
my( $ID, $recipID, $NAME, $age);
$sth->bind_columns( undef, \$ID, \$recipID, \$age);
print<<"[HTML]";
$age
[HTML]
-----------------------------
Thanks in advance