php mysql question

infected · 10-31-2004, 01:57 AM

im creating a very simply blog program and got stumped. My mysql table has a text field which contains the text of the blog, what i want to do is on the front page just show a certain length of the blog entry say only 200 characters. What is the best way to implement this? should i get the entire text from the table and use php functions to display a certain length or does there exist an sql statement that does it for me?

infected · 10-31-2004, 01:04 AM

of i found Left(variable name, length) that would do it, any other suggestions?

m_shroom · 10-31-2004, 09:50 PM

Quote:

Originally posted by infected
im creating a very simply blog program and got stumped. My mysql table has a text field which contains the text of the blog, what i want to do is on the front page just show a certain length of the blog entry say only 200 characters. What is the best way to implement this? should i get the entire text from the table and use php functions to display

It is very easy with php

Code:

$disply=substr($artical, 0, 200);