limit characters in mysql results with php

[atticus]

Hi,

 

I am trying to figure out the best way to limit the amount characters displayed in a result with php from a mysql database.  For example, when a user clicks on the category and a list of products are shown, I would like to display the first 150 characters from the field in the database about that product with "..." following.  I am a noob to php and I am not really sure where to start with this one.

 

Thanks in advance.

 

 

[darkfreaks]

in your query put LIMIT 150

[atticus]

wouldn't that just limit the amount of rows from mysql, I would actually just like to display the first 150 characters from 1 database field(row).

[atticus]

alright, figured it out.  Here is the solution:

 

$newstring = substr($description,0,150);
echo $newstring

[corbin]

You could also do it with MySQL.

 

SELECT SUBSTRING(col1, 0, 150) FROM table;