Posted by Jerry Stuckle on 02/07/06 13:19

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
==================

• Next in forum: Re: An encrypting function.
• Prev in forum: Re: How do we assign 16 bytes unsigned Integer in PHP?
• Thread view: Re: Return bool from query

[Reply to this message]