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

import table with dependency
Hi

What is the best way to import table back which has dependency?

SQL> cre

upload only text files
hi guys i want to upload only text like like (pdf,note pad and ofiice files) so can any one please t

SESSION question
I am building an application , a directory for auctions.
For SEO i made a script which copies a p

Problem with the Update command used with a sqldataadapter
I'm connected to a database on an SQL Server and I'm using a sqldataadapter, sqlconnection, sqldatas

DataTable Help Required
Hi all I am creating an app that utilises and MS Access back end and queries it quite a bit at vario

Form a inline view based on the results of the previous query?
Hi Experts,
Can we form a inline view on the results of a previous query (another inline view)?

how can we add data from dynamic fields to mysql db in php
i have a script which i found on the internet. i modify that script according to my needs. what is i

email form (cannot find the problem)
Hello there. I've been having trouble with an email form. Can't find the problem really. I've tested

EU VAT Package 2010
Does any one know whether SAP will be developing new reporting functionality due the new VAT rules t

Is STL important?
I'm just starting programming and I've made it until the Standart Template Library. But the chapter