Display how many characters a field have

i have a field, the field name is name, like
John
Robert
etc

the variable to call name is $name



now i need to display how many characters each name have, for example
John : 4 characters
Robert : 6 character

how to get characters numbers by using the name variable $name, what is the query looks like?


thank you & GBU for all that helping

 

Try strlen: http://php.net/manual/en/function.strlen.php

 

select name, length(name) from table --- this will display the name and the length of the field

 

To get strings like
John : 4 characters
Robert : 6 characters

Your code should be:
print $name." : ".strlen($name)." characters" ;

BR,
Marcel