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

New Login Script
Hi all, i attempted to create a whole new login script witch isnt working for some reason i dont kno

"SEO" URLs
Hey, I'm wondering how to go about creating and using these types of URLs. I'm presuming it's PHP th

Using CSS to format MySQL query
Hi,

If i want to have a news page on my site, which displays all records of a table in descen

Concatenate two strings ???
I have string one $string1 and another $string2.

How to concatenate (add) both of them $str

SMTP server...
I recently found a tutorial online on SMTP authentification for sending emails from webpages, here i

OOP help
okay so i have a class im making it has everything setup i just need to randomize the 2 variables an

MySQL query problem
When I try to run the following piece of code, I get this error:
QuoteWarning: mysql_query(): sup

webpage with (simple) login & mysql-db
Hi all,

What I was looking for before was a multi-user password manager, web-based! The offer

Help Optimizing code
Good Morning,

I wrote a small import function for a website of mine and I know there has to b

Require select-option functionality in Module Pool Programming
Hi Gurus,

I am doing a development by Module Pool on Warehouse Management. For that devel