Posted by Harry Rose on 08/14/05 02:46

Hi all, this has probably been posted many times before (sorry, i did
look, honest).

At the moment I'm trying to write my own portal and columns for my 'news
posts' table include one called 'contents', which has the contents of the
post in it and can hold up to 1000 characters.

First of all, this is type LongText which i thought would be better than
Blob (although to be honest i'm not sure what the difference is). Is that
ok?

Secondly, is there a command to only read the first 500
characters from that column? As my early attempts at doing something like
this didn't work because of an 8MB memory limit :-) (although that was
using blobs).

Having read that, thats more SQL question than PHP, but its for a PHP
project, I promise :).

Thanks

Harry

• Next in forum: Re: inserting multiple lines from one form
• Prev in forum: Re: include security -what works, what dont?
• Thread view: Recieving bits of SQL data

[Reply to this message]