Fw: [PHP-DB] RE: [PHP] Get just first 200 characters of field?

----- Original Message ----- From: "Mark Roedel" <roedelm@letu.edu> To: "James Montz" <jmontz@ncn.net>; <php-db@lists.php.net>; <php-general@lists.php.net> Sent: Wednesday, October 18, 2000 7:17 AM Subject: [PHP-DB] RE: [PHP] Get just first 200 characters of field? > > -----Original Message----- > > From: James Montz [mailto:jmontz@ncn.net] > > Sent: Wednesday, October 18, 2000 9:01 AM > > To: php-db@lists.php.net; php-general@lists.php.net > > Subject: [PHP] Get just first 200 characters of field? > > > > > > Im working on my own news managment system for my web site, and I > > would like to be able to post on the main page the article header, > > and just the first 200 or so characters of the actual content of > > the article. > > > > How can this be done? Using PHP3 and MySQL? Is there a specific > > PHP or MySQL function that would accomplish this? > > Using PHP: > substr() > http://php.net/substr > > Using MySQL: > left() or substring() > > http://www.mysql.com/documentation/mysql/commented/manual.php?section=String > _functions > > > --- > Mark Roedel | "Blessed is he who has learned to laugh > Systems Programmer | at himself, for he shall never cease > LeTourneau University | to be entertained." > Longview, Texas, USA | -- John Powell > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net >