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 read and write into a word document using php...?
hi,
I need,reading and writting into a word document using php.




Thank u inadva

MVC - Code review
I'm in the process of trying to wrap my head around MVC, and as part of that, I'm attempting to impl

php calculate
this code echoes correctly the sum but the inserted result is 0??
Code: <?php
$TotalNum

Automatic Webpage ??
I have a page www.mysite.com/test.php with a
<form>
<textarea name=&q

A Few Questions
Hi, I want to ask a few questions that I can't seem to find..

1) I'm creating a "shortcu

standard ALV application toolbar, into custom report....
HI,

I have a question regarding displaying standard ALV menu path and application toolbar

Filling gaps in dates
So i'm doing a query for sales data and my return array looks like this

('date' => '20

Rounding a number queried from a database
I know that to display a rounded number you just do echo "round($number)";. But how would

Significance of BPM
Hi Experts,
I am a novice in BPM , I just want to know how BPM as permenant department is

displaying unknown amount of results
I am reading a directory and getting a list of folders in the directory, I want to display the folde