limit each row of a mysql query to 9char

[Anon]

hello,
i am trying to pull news headlines into a php page. the table i'm putting the headlines into are only 200pixels wide.. so i only want to pull about 10-20 characters from the query. then when the user clicks on the link, they would get the full headline and story.

will someone show me an example mysql_query of how i would select the first 10 characters of the field "headline" in a table named "news".

thanks in advance for any help.
-mike

[wombatee]

No problem... check out the string functions in the MySQL manual at <a href='http://www.mysql.com/doc/S/t/String_functions.html'>http://www.mysql.com/doc/S/t/String_functions.html</a>. Here's what you do:

SELECT SUBSTR(headline,1,10) FROM news

Cheers!

Omega Wombat
http://www.drinknation.com

[Anon]

thanks a lot omega!