LIMIT'ing output

[DeathStar]

hi there.

I want to limit an output from an query to dispaly only the first x leters.

the coulom looks like this:

|    Text            |

------------------

| Data from a post|

I think its a LIMIT command but cant find such a sql command on google ?!?

 

I'm trying to do this with:

 

$reson = mysql_query("SELECT reson FROM users LIMIT 10");
echo $reson;

[Orio]

You want the 10 first letters or records?

For records, you are right- you use LIMIT 10.

But for letters, you need to use the substr() function:

 

<?php

$text = "abcdefghijklmnopqrstuvwxyz";
echo substr($text, 0, 10);
//Output- first 10 chars- abcdefghij

?>

 

 

Orio.

[DeathStar]

and to find out if it is even 10 letters long it would be?

 

$string1 = ($s['string']);
ubstr($string1, 0, 10) = ($s['string2']);
$find = ($strino); // and there i got lost...

[Orio]

<?php

function max_10 ($str)
{
if(strlen($str) <= 10)
	return $str;
else
	return substr($str, 0, 10);
}

?>

 

 

Orio.

[DeathStar]

Edited a bit..

if(strlen($str) <= 10){
	echo "$str";}
else{
	 $substr = substr($str, 0, 10);
	 echo "$substr...";
	 }

 

Thanks