Thursday, March 4, 2004, 10:27:34 AM, you wrote:
TPrsc> You know in PHPmyADMIN...
TPrsc> if you hav a large field, and hit browse, you only see some fo the text...
TPrsc> is this a PHP thing, or a MySQL thing... more improtantly, how can I do
I don't know how PHPmyAdmin does it, but you can do this in SQL
directly without having to do it in PHP. Look at the SQL functions:
LEFT(), MID(), RIGHT() and SUBSTRING().
SELECT LEFT(longfield, 100) FROM table
This will bring back the first 100 characters from the longfield
column (assuming it has 100 characters in it).
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php