Showing text

[zingbats]

Hi...

I have a $tag which is a block of text. How can I make it show the first say 50 words of tag?

Also...

how can I make a MySQL column that is a position column..? (Where the position is detirmined by the number of points - DESC [highest at top])

Regards;
Alex

[shawon22]

//the following code is to get only 50 character 
$subtag = substr(strip_tags ($tag), 0, 50);

//to get words
//there might be a better way to do this but i use the following code

$words = explode(" ", $tag);

for($i=0; $i<50; $i++)
$nwords[$i] = $words[$i];

$t_50_words  = join(" ", $nwords);