first 12 characters of a string

[frans-jan]

Hi,

I encountered the following problem, I want to show the first 12 characters as a result from a MySQL query.

I the php manual I found the following:

<?
$tmp = 0;
$s = "I have 20 points";
while($tmp < 12 && $c = $s[$tmp++]) { echo $c; }
?>

What happends is that the result will stop at the "0" (using php 4.0.5). thus:
i have 2

I know it can be done showing the first xx characters but how to do it if the text contains zero's?

Thanks, Frans-Jan Wind

[domcrayford]

not quite sure about the why or what with your method, but what about using substr...

substr(string, start, length)

so $first12 = substr($wholething, 0, 12);

or if you're using MySQL, let it do the work for you...

SELECT substring(Field1, 1, 12) AS First12, Field2, Field3 from Table;

is this what you're after?

dom
🙂