only return 200 characters? pleese help

[satch]

need to select only the first 200 characters of a text row in MYSQl. I have this and it does not work.

$entry_result=MYSQL_QUERY("SELECT headline,LEFT(article,200) FROM articles_entry WHERE author_id = $row[id]");

am i doing this wrong?

thanks in advance

[satch]

I figured it out!!! ofr course one I posted.. lol

I needed to add the "as"

thanks!