Re: [PHP-DB] Re: SELECT query

2008-12-21 Thread Chris
Bastien Koert wrote: On Sun, Dec 21, 2008 at 7:56 PM, Ron Piggott wrote: One more thing ... Bible is stored by verses, t is the text of the verse On Sun, 2008-12-21 at 19:52 -0500, Ron Piggott wrote: I am working on a web based Bible searching query. So far I am able to generate: SELECT *

Re: [PHP-DB] Re: SELECT query

2008-12-21 Thread Bastien Koert
On Sun, Dec 21, 2008 at 7:56 PM, Ron Piggott wrote: > > One more thing ... Bible is stored by verses, t is the text of the verse > > On Sun, 2008-12-21 at 19:52 -0500, Ron Piggott wrote: > > I am working on a web based Bible searching query. So far I am able to > > generate: > > > > SELECT * FRO

[PHP-DB] Re: SELECT query

2008-12-21 Thread Ron Piggott
One more thing ... Bible is stored by verses, t is the text of the verse On Sun, 2008-12-21 at 19:52 -0500, Ron Piggott wrote: > I am working on a web based Bible searching query. So far I am able to > generate: > > SELECT * FROM `bible_verses` INNER JOIN `bible_books` ON > `bible_books`.`id` =

[PHP-DB] SELECT query

2008-12-21 Thread Ron Piggott
I am working on a web based Bible searching query. So far I am able to generate: SELECT * FROM `bible_verses` INNER JOIN `bible_books` ON `bible_books`.`id` = `bible_verses`.`b` WHERE `t` IN ( 'Lord' , 'Jesus' ) LIMIT 0 , 10 Is an "IN" the correct syntax to use? I am trying to take what the use

Re: [PHP-DB] ntwdblib.dll not found in any of the 5.2.8 zip files

2008-12-21 Thread Chris
Fred Silsbee wrote: --- On Sat, 12/20/08, Fergus Gibson wrote: From: Fergus Gibson Subject: Re: [PHP-DB] ntwdblib.dll not found in any of the 5.2.8 zip files To: fredsils...@yahoo.com Date: Saturday, December 20, 2008, 6:06 PM On Sat, Dec 20, 2008 at 7:59 AM, Fred Silsbee wrote: ntwdblib.

Re: [PHP-DB] MySQL Conditional Trigger

2008-12-21 Thread Chris
Aleksandar Vojnovic wrote: You could try with the <> operator. !=, <>Not equal operator Same issue as using '=': mysql> select 2 <> null; +---+ | 2 <> null | +---+ | NULL | +---+ 1 row in set (0.00 sec) Comparing anything with null returns null. (I'm not askin