http://dev.mysql.com/doc/refman/5.0/en/string-functions.html
I recommend "LEFT( )".
If you are looking to do it in PHP then this is the wrong email list.
Good luck.
b.
CodeHeads wrote:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hello all,
Have a question:
I would like to limit the amount of data viewed. I searched but did not
find anything.
Here is my code:
$get_c = "select * from $table ORDER BY news_id DESC LIMIT 5";
$get_c_res = mysql_query($get_c) or die(mysql_error());
while ($c = mysql_fetch_array($get_c_res)) {
$news_id = $c['news_id'];
$news_posted = $c['news_posted'];
$news_subject = $c['news_subject'];
$NEWS_D = nl2br(stripslashes($c['news_desc']));
}
I would like to limit $NEWS_D to say 100 characters.
- --
Best regards,
~WILL~
Key: http://code-heads.com/keys/ch1.asc
Key: http://code-heads.com/keys/ch2.asc
Linux Commands: http://code-heads.com/commands
Linux Registered User: 406084 (http://counter.li.org/)
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2.2 (GNU/Linux)
Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org
iD8DBQFEIaDzfw3TK8jhZrsRAuZsAJ9S6QCvo6Pyru45qh1dzzANyD/OUgCgpuTG
RqcZaNUSgSA4TvHRusMzn18=
=P+Is
-----END PGP SIGNATURE-----
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
