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

foreach and array need help combining
Hi guys.

Here's the code

Code: array(
'tag' => 'code',<

send() and recv() parameters confusion
On server Side:
int recv (Socket,Buffer, Length, Flags)
On Client Side:
int send (Soc

Month String to Numeric?
Hi guys,

Given a month as a string, is there a simple way to find the numeric representation

Gridview Not updating in Update Panel
I have a gridview, three dropdown list boxes, and a button on my form. What is displayed in the gri

Simple program to copy files between two computers over the web
I use logmein free and often need to move files between my two computers. Generally, I move the file

RSS poster script?
I have found a script that posts RSS's for me on a site that I'm building. However I would like to a

single values into sql field
i have a form which i want the user to able to select multiple answers. But i want the answers to be

help with contest script
I would like to code a contest script to my site but i don't know how. Could someone just give me pu

Blank record injected into database
I always found several blank records inside my database, although $SESSION is required to insert the

file_put_contents and createimagefromjpeg
All,
I do somethings and then I have the following code:
file_put_contents('./test/'.$filename