I think I'm overthinking/overcomplicating this, and am at a point where I need to ask the experts here...
My database contains the fields firstname and lastname. After querying the database I want php to return the first initial and the full lastname. So "John Doe" becomes "J Doe". Anyone know how to do this, or can anyone point me in the right direction?
Many thanks!
Use SUBSTRING and CONCAT, something like...
SELECT (CONCAT(SUBSTRING(firstname, 1, 1), ' ', lastname) FROM table
Ah, cool thanks 🙂
