Formatting echo from database

Posted on 16th Feb 2014 07:03 pm by admin

So I have a database that stores First and last names, then echos them back to a website, as of now the entire first and last name echos back (John Smith) I want the last name to just display the last letter and a . (John S.) here's my code for echoing the database

Code: <?PHP
$res = mysql_query("SELECT id, DATE_FORMAT(date, '%M %D %Y') as dt, firstname, lastname, testimonial FROM testimonials ORDER BY date DESC LIMIT 10");

while ($row = mysql_fetch_assoc($res)) {
echo "<p align="right"><i>{$row['firstname']} {$row['lastname']}<br />{$row['dt']}</i></p><br /><br />{$row['testimonial']}<br /><hr width="80%" color="#000000"><br />";
}
?>

Your Answer:

Login to answer

Other forums

How do I replace any number of character occurences with one occurrence?
How do I replace any number of character occurences with one occurrence?

Let's say I have:

Appending GET data with form submition
Okay, what I'm trying to do is to use a form to append an already existing GET data string.

I

mail() says sent but no email received
My code is quite simple:

Code: <?php
$to = "Ty44ler@yahoo.com";
$subje

PHP friend keyword equivalent
is there a PHP equivalent for the C++ friend keyword?

string to currency format
Hi guys...

Actually I chunk out some data from txtfile and one of the data contains amount va

Storing Values taken from a DB...
Using this code it will generate a short list from my database

<?php
mysql_connect

Random date selection
i want to select random date with time(hour+minutes+sec) where date is specified(10/22/2009) and tim

MS are the best!!!
Visit http://www.microsoft.com/australia/windows/default.aspx?h=watch-a-demo and click the massive '

Removing Title From database problem
Hi again ! i am having an issue with updating database. When i update any price of a title it remove

script is pulling more then they have....
I have this script for my game where they can change there race. This will cost them 2,500 points. H