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

show random images
hey guys

can someone please suggest a way in which the following code can be edited so it onl

Any Good MMORPGs you've played?
I'm about to have ALOT of free time on my hands (finished highschool) and I need something to fill t

IIS7 and getimagesize() problem
I have just discovered after hrs of trying to fix a problem where it's coming from. It's to do with

in php, link returns to the line
When I add a link in a php page, the link word returns to the line (as a
would do)

Examp

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

multipart emiail forms
Hi All,

I am new to the boards and I've been working on a form (which is rather massive, imo

TemplatePower & AJAX
Hi all,



I'm currently implementing some AJAX features in my PHP-framework (which is b

Calculus Help (and by help I mean homework)
Hrmmm, I hate posting about math homework, partly because it's homework, and partly because I hate w

PHP XML extraction text
I would like to extract an xml text and have that text directly echo(print) out on my web page. Her

Local file browser with php
Halo..

So this is what i want to create. I have a folder that i share and it has many movies.