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

I got my hosting suspended XD
So I saw this challenge a day or so ago

http://www.programming-challenges.com/pg.php?page=dow

Change Web page language
i doing this thing first time but i dont find any suitable solution for it. On the demand of user. I

Multidimensional $_POST
Hello

How to get a single array from array of array (2 - dimension).
For example I have a

pagination - need help on passing of search query.
Hi, i have been trying for days but couldn't get this sorted out. Would like some professional help

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

Array becomes unset by itself?
Hi,

I have a bit of experience with PHP but not extensive. It seems I cannot store any items

Typedef struct vs just struct
Anyone know the rationale for using typedef for structs when a struct is itself a typedef? I have s

insert quotes
Hi,

I have an output like this:
Code: john,18,Cancer
How can I change this to
Code:

show random images
hey guys

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

Help on query replacing the date
Hi Pals,

i want to replace the current date in a column to some value say C or D or any n