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 to grab certain words ??
I am working with this API

Returns JSON.
curl http://letsbetrends.com/api/current_trends

Linkage between two scripts
Okay say I have this for a link in a script:

Code: <li><a href="#&q

Contact Form Not Working When I Add Validation Codes
So I built my first working PHP "Contact Us" like form. But, I have been trying to now mak

Connection Timeout
I'm using xmii 12.0

I'm calling a transaction as a web service from a windows application

utl_file open error
i have file in the unix path

Path /popdev01/pop/popdevb/tfi/

File name

[newb] Image hosting help.
Hey there, I'm new to php, I know some basics and i can code PWN, I'm only 14 but I'm interested in

frames get header location..
i have two frames, one top, one bottom. how do i do a form on the bottom frame that gives me the ur

PHP Programming error. Please help!
Hi there,

Am making a website for a friend and have encountered a problem that i need fixing

returning data from an ssh2_exec()
here's what i got.


$conn = ssh2_connect($this->_host);
ssh2_auth_password($c

Small problem with image resize script
Hi!

I am a little bit new to php and I have an issue installing an image resize script I down