Try using MySQL to do that right in the query itself (and save the
overhead of retreiving the whole blob then PHP'ing the blob too).
From the MySQL Doc's ;-) RTFM once at least
--
SUBSTRING(str,pos,len)
SUBSTRING(str FROM pos FOR len)
MID(str,pos,
"Jon Farmer" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
>> From: Johannes Janson [mailto:[EMAIL PROTECTED]]
>> Sent: 13 August 2001 12:15
>> To: [EMAIL PROTECTED]
>> Subject: [PHP-DB] Re: Show abbreviated art
428969
Mob 07968 524175
-Original Message-
From: Johannes Janson [mailto:[EMAIL PROTECTED]]
Sent: 13 August 2001 12:15
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Re: Show abbreviated article
hi,
[...]
> My question is this: how can I select only those first 20 words in the
> PHP code?
hi,
[...]
> My question is this: how can I select only those first 20 words in the
> PHP code?
SELECT LEFT(YourBlobFiekd, 20) FROM YourTable;
hope it helps
Johannes
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail:
