Simple Question With Php/mysql Output

[patheticsam]

Hi!

 

I'm new to php and I have a really simple question..

 

I have some text stored in a MySQL database and i'm outputting the texts like this :

 

$data = mysql_query("SELECT * FROM lva_artistes ORDER by RAND() LIMIT 0,2")
or die(mysql_error());
while($info = mysql_fetch_array( $data ))
{
								 echo $info['text'];
							 }

 

Since it's a long text I want to know if there's a way to output only the first X characters (ex: only de first 500 characters)...

 

If anyone can point me to a tutorial or the right function it would be really appreciated..

 

 

Thanks!!

[Pikachu2000]

Either with the MySQL function SUBSTRING(), or with the PHP function substr.

[patheticsam]

Got it, works perfectly....Thanks!!!