Posted by Jim Michaels on 02/12/06 11:00

FULLTEXT() is a MySQL search function. so you might want to name your
column something else.

"Jerry Stuckle" <jstucklex@attglobal.net> wrote in message
news:NfGdnYBUjZ7RH3XeRVn-ug@comcast.com...
> frizzle wrote:
>> Hi there,
>>
>> I have a mySQL system with a news publishing part in it:
>> Admins can create new items with text in it, and they have an option to
>> create 'fulltexts', so you'd get "read more ..." on the front page,
>> click it and read the fulltext.
>>
>> Is there a possibility for mySQL (query) to check if 'fulltext' is
>> empty or not, and only return true or false, so i don't have to put the
>> whole fulltext into the mysql_fetch_array() to decide wether or not to
>> show 'read_more', or should i create an extra boolean field in the DB
>> saying fulltext y/n ?
>>
>> Greetings Frizzle.
>>
>
> Put it in a separate table with just the article's id and the text. If
> the id exists in the second table, there is more text.
>
> --
> ==================
> Remove the "x" from my email address
> Jerry Stuckle
> JDS Computer Training Corp.
> jstucklex@attglobal.net
> ==================

[Back to original message]