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

Curly Bracket Delimeters.
I'd always believed that the starting and ending delimeters in preg_ functions had to be the same ch

How to read CSS message data
Hi,
I have a requirement here. When working as a Dev angel for multiple customers its really di

need help with mail()
hi i want to send an email with attaching pdf file using php. i have the following script but the pr

Thread in PHP
Thread in PHP
Some basic use and basic code for thread in php
This is my question?

Putting double spaces instead of single spaces
Im looking at trying to replace all single spacing between fields with double spacing

At pres

Help With Showing Users On the Index Page
Ive got this code which works just how i want it to.

Code: <?
$timenow=time();

Delete HTML file after loading
I have limited experience with php and its been a year or two since I've last used it. I have a sma

Upload file and add HTML
Hey everyone,

I have a client has meeting agendas and minutes that should be posted online. I

Get to know your fellow coder
I think it's time we got personal around here. There's a lot of code swapping and a few members kno

Run function every 5 mins ??
I have a function PostMessage()

How can I run it every 5 mins ??