Showing only first 100 letters of result

[nicdp]

How can I show only the first 100 letters of a result of a mysql Query?

[[deleted]]

use substring

RTFM:

http://www.mysql.com/doc/S/t/String_functions.html

[mickro]

Nico,

You could use either:

$query = mysql_query("SELECT SUBSTRING(text,0,100) as short_result FROM table");

$result = mysql_fetch_array($query);

echo $result["short_result"];

or

$short_result = substr($result,0,100);

echo $short_result;

HTH

Mike
www.digitalegg.net

[nicdp]

But something like this doesn't work

function getLeggi($db,$gruppo_l){
$select = sprintf("SELECT * FROM db_leggi WHERE gruppo_l = '$gruppo_l' ORDER BY numero_l DESC");
$short = substr("$select",0,10);
return $db->query($short);
}

[Anon]

Of course not: you're trimming the query command, not the result!

[nicdp]

So... what should I do?

[mickro]

Nico,

This is how I would do it:

$query = mysql_query("SELECT * FROM db_leggi WHERE gruppo_l = '$gruppo_l' ORDER BY numero_l DESC");

$result = mysql_fetch_array($query);

$short = substr($result["gruppo_1"],0,100);

// Replace gruppo_1 with the field you want to trim

So you are trimming the result and not the query as Kirk says.

HTH

Mike