How to limit charachters from a database query

[shalli]

Hi there

 

Been trying to figure this out but how do you limit charachters on a mysql query

 

<?php

//$qry="select * from news where status=1 order by date_Added DESC";

$qry="select * from wp_posts order by post_date DESC";

$sql=mysql_query($qry,$connBlog);

//$news=mysql_fetch_array();

while($news=mysql_fetch_array($sql)){

$arr[]=$news['post_title', 0, 25];?>

js_ar.push("<?=$news['post_title']?>");

<?php }?>

 

thanks

 

shalli

[mikosiko]

2 possible options:

a) use the SUBSTRING() function directly in your sql query

b) use the SUBSTR() function in PHP

[shalli]

Thanks mikosiko

 

For all your help!!