Initialize

[phpretard]

How can  pull just the first letter from a row in a DB?

 

I need initials only from fisrt and last name.

 

$result = mysql_query("SELECT * FROM table");
while($row = mysql_fetch_array($result))
  {
  $initials=$row['FirstName'] . " " . $row['LastName'];

  echo "Initials Only";
  }

mysql_close($con);

 

 

Thanks for your help...

 

 

[rhodesa]

This should work:

<?php
  $result = mysql_query("SELECT * FROM table");
  while($row = mysql_fetch_array($result))
  {
    $initials=$row['FirstName']{0} . " " . $row['LastName']{0};

    echo "Initials Only";
  }
  mysql_close($con);
?>