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

data type in column definition
Hi,
I create a table with column called "Direction of Travel code ".
The travel codes in t

Select all entries from database that include a phrase
I have a database of clubs - one of the categories is meeting time and place
I would like to have

strtotime issue
Hey all,

I'm playing around with some code, and basically the idea is:

Person changes

C++ API to Oracle dB
I need to perform a select command to the Oracle dB to obtain information from a table.
What libr

Javascript form submit and radio buttons?
When this form is submitted, it is automatically resubmitted using JS.

All my fields are carr

Access website from only 1 computer...?
One of my customers wants his website to only be accessed by people in which they bought the website

is_dir() problem
Hello,

I'm buidling a php scripts that dynamically get's subfolders from a specific folder.

INSERT for date range
Hi all

I have the following table

Code: [Select] `date` date
`day` int(2)
`

Help building / using array
First - this is a cross-posting, if this is wrong I apologise! What started out as a MySQL query que

To add a field on the screen XK02.
Hi All,

How to add an additional field in the vendor change control screen XK02.
The