<div>
<div class="content wysiwyg-content">
Hello 
I have in my database users, fields name username who contains for instance the value dialogoo 
I need to write a simple select function that selects: 
pix1/d/di/dialogoo-1.jpg 
 
pix1 is FIXED 
d is the first letter 
di are the first 2 letters 
-1.jpg is fixed 
 
so it it something like 
SELECT &quot;pix1/&quot;+{firstLetter(username)+&quot;/&quot;+{first2Letters(username)}+&quot;/&quot;+{username}+&quot;-1.jpg&quot; 
Any clue ? 
 
regards
</div>
</div>

Hello
I have in my database users, fields name username who contains for instance the value dialogoo
I need to write a simple select function that selects:
pix1/d/di/dialogoo-1.jpg

pix1 is FIXED
d is the first letter
di are the first 2 letters
-1.jpg is fixed

so it it something like
SELECT "pix1/"+{firstLetter(username)+"/"+{first2Letters(username)}+"/"+{username}+"-1.jpg"
Any clue ?

regards

mysql concat and substr simple question

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.