Return bool from query

[frizzle]

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_arr ay() 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.

[Jerry Stuckle]

frizzle wrote:

I actually use PHPmyAdmin, but don't know where to set it to INNODB, or
my host disabled that, (i can choose form 3 other ones though ...)

Frizzle.

After you select the table, go to the Operations tab. One of the
entries is "Table type". Change this to INNODB.
--
=============== ===
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attgl obal.net
=============== ===

[frizzle]

Jerry Stuckle wrote:

frizzle wrote:

I actually use PHPmyAdmin, but don't know where to set it to INNODB, or
my host disabled that, (i can choose form 3 other ones though ...)

Frizzle.

After you select the table, go to the Operations tab. One of the
entries is "Table type". Change this to INNODB.
--
=============== ===
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attgl obal.net
=============== ===

The only options i get there are:
- MyISAM (current)
- Heap
- ISAM
- Merge

So i guess it's not possible (yet). But i have things up and running
correct now, or do you think it's that important to go use foreign
keys?

Frizle.

[Jerry Stuckle]

frizzle wrote:

Jerry Stuckle wrote:

frizzle wrote:

I actually use PHPmyAdmin, but don't know where to set it to INNODB, or
my host disabled that, (i can choose form 3 other ones though ...)

Frizzle.

After you select the table, go to the Operations tab. One of the
entries is "Table type". Change this to INNODB.
--
============= =====
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@att global.net
============= =====

The only options i get there are:
- MyISAM (current)
- Heap
- ISAM
- Merge

So i guess it's not possible (yet). But i have things up and running
correct now, or do you think it's that important to go use foreign
keys?

Frizle.

OK, you're hosting company may have an older copy of MySQL, may not have
installed INNODB support or whatever.

INNODB will allow you to ensure the integrity of your foreign keys. For
instance, if you delete a row in your main table, it can automatically
delete the matching row(s) in your full text table (other options are
available also). Without it, you can't guarantee the integrity of the
database.

So it all depends on how important it is to you. You'll probably be ok
- this isn't like a bank, for instance, where you don't want to delete a
person's record while they still have open accounts. If you have some
extra rows in your full text table it might slow the server down a
couple of milliseconds is all.
--
=============== ===
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attgl obal.net
=============== ===

[frizzle]

Jerry Stuckle wrote:

frizzle wrote:

Jerry Stuckle wrote:

frizzle wrote:

I actually use PHPmyAdmin, but don't know where to set it to INNODB, or
my host disabled that, (i can choose form 3 other ones though ...)

Frizzle.
After you select the table, go to the Operations tab. One of the
entries is "Table type". Change this to INNODB.
--
============= =====
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@att global.net
============= =====

The only options i get there are:
- MyISAM (current)
- Heap
- ISAM
- Merge

So i guess it's not possible (yet). But i have things up and running
correct now, or do you think it's that important to go use foreign
keys?

Frizle.

OK, you're hosting company may have an older copy of MySQL, may not have
installed INNODB support or whatever.

INNODB will allow you to ensure the integrity of your foreign keys. For
instance, if you delete a row in your main table, it can automatically
delete the matching row(s) in your full text table (other options are
available also). Without it, you can't guarantee the integrity of the
database.

So it all depends on how important it is to you. You'll probably be ok
- this isn't like a bank, for instance, where you don't want to delete a
person's record while they still have open accounts. If you have some
extra rows in your full text table it might slow the server down a
couple of milliseconds is all.
--
=============== ===
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attgl obal.net
=============== ===

Ok, thanks a lot for all the effort. No more further questions ...
for now ;)

Again, thanks a lot for taking so much time!

Frizzle.

[Jim Michaels]

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

"Jerry Stuckle" <js*******@attg lobal.net> wrote in message
news:Nf******** ************@co mcast.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_arr ay() 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.
js*******@attgl obal.net
=============== ===

[Jim Michaels]

"frizzle" <ph********@gma il.com> wrote in message
news:11******** **************@ g14g2000cwa.goo glegroups.com.. .

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_arr ay() 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.

if you create the column with type TEXT or LONGTEXT (or whatever) with
DEFAULT NULL, you can use MySQL's ISNULL() function to detect if it's empty
or not.
for instance,
SELECT ISNULL(fulltext 1) FROM tablename ORDER BY itemtimestamp DESC

you can in your code with $row=mysql_fetc h_array() see if $row['ISNULL']
(not sure if it should be lower case here) has an appropriate value. echo
it to find out.