Re: [PHP-DB] Re: SELECT query
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 * 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?
This will work fine. An "IN" clause is like multiple OR's:
... where t = 'Lord' OR t = 'Jesus' ...
I am trying to take what the user types in (variable is $keyword_search)
and allow a search where if the same 2 or 3 words are in the verse of
the Bible that verse would be a match, but not necessarily be beside
each other.
$keyword_search_string = str_replace(" ", "' , '", $keyword_search);
$query .= "IN ( '" . $keyword_search_string . "' ) ";
This will seem a little long winded but you need to check for sql
injection. As it stands, you'll get an error when you search for a name
with a quote (o'reilly). Might not be in the bible (I have no idea) but
doesn't mean someone won't try it ;)
// look at the keywords one by one - they are space separated
$keywords = explode(' ', $keyword_search);
// now go through them all and escape them.
$keyword_searches = array();
foreach ($keywords as $keyword) {
$keyword_searches[] = mysql_real_escape_string($keyword);
}
// then turn it all into an "IN" string.
$keyword_search_string = "IN ('" . implode("','", $keyword_searches) . "')";
You may want to eventually look at full text searching, depending on how
slow this is and how important search is to your site. The syntax is
completely different.
http://dev.mysql.com/doc/refman/5.0/en/fulltext-search.html
--
Postgresql & php tutorials
http://www.designmagick.com/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Re: SELECT query
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 * 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 user types in (variable is $keyword_search)
> > and allow a search where if the same 2 or 3 words are in the verse of
> > the Bible that verse would be a match, but not necessarily be beside
> > each other.
> >
> > $keyword_search_string = str_replace(" ", "' , '", $keyword_search);
> > $query .= "IN ( '" . $keyword_search_string . "' ) ";
> >
> > How do I do this correctly?
> >
> > Ron
> --
>
> Acts Ministries Christian Evangelism
> Where People Matter
> 12 Burton Street
> Belleville, Ontario, Canada
> K8P 1E6
>
> ron.pigg...@actsministries.org
> www.actsministrieschristianevangelism.org
>
> In Belleville Phone: (613) 967-0032
> In North America Call Toll Free: (866) ACTS-MIN
> Fax: (613) 967-9963
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
query code looks correct. are you getting an error? have you tried echoing
out the sql and testing in phpmyadmin or some other gui tool?
--
Bastien
Cat, the other other white meat
[PHP-DB] Re: SELECT query
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` = `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 user types in (variable is $keyword_search)
> and allow a search where if the same 2 or 3 words are in the verse of
> the Bible that verse would be a match, but not necessarily be beside
> each other.
>
> $keyword_search_string = str_replace(" ", "' , '", $keyword_search);
> $query .= "IN ( '" . $keyword_search_string . "' ) ";
>
> How do I do this correctly?
>
> Ron
--
Acts Ministries Christian Evangelism
Where People Matter
12 Burton Street
Belleville, Ontario, Canada
K8P 1E6
ron.pigg...@actsministries.org
www.actsministrieschristianevangelism.org
In Belleville Phone: (613) 967-0032
In North America Call Toll Free: (866) ACTS-MIN
Fax: (613) 967-9963
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] SELECT query
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 user types in (variable is $keyword_search)
and allow a search where if the same 2 or 3 words are in the verse of
the Bible that verse would be a match, but not necessarily be beside
each other.
$keyword_search_string = str_replace(" ", "' , '", $keyword_search);
$query .= "IN ( '" . $keyword_search_string . "' ) ";
How do I do this correctly?
Ron
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] ntwdblib.dll not found in any of the 5.2.8 zip files
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.dll proves to be necessary...otherwise I'll get a mssql_connect not found I used the ntwdblib.dll file from a 5.2.6 zip file This resource might help: http://www.userscape.com/helpdesk/index.php?pg=kb.page&id=13 According to the information there and on the forum thread they link, the problem you have is likely that the ntwdblib.dll is the wrong version. They say you can find the correct DLL in the system32 directory on the SQL Server. If you copy that to your extension dir, you should be good. YOU ARE THE MAIN MAN! THAT WORKED! THE CORRECT VERSION SHOULD BE INCLUDED IN THE 5.2.8 ZIP FILE So lodge a bug at http://bugs.php.net. -- Postgresql & php tutorials http://www.designmagick.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] MySQL Conditional Trigger
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 asking for a solution, I'm stating it as fact). Or you could try it this way - ISNULL(col_or_data_to_check). Example: mysql> SELECT ISNULL(1+1); +-+ | ISNULL(1+1) | +-+ | 0 | +-+ 1 row in set (0.02 sec) You can also use 'coalesce' to set default value for null columns. http://dev.mysql.com/doc/refman/5.0/en/comparison-operators.html#function_coalesce http://dev.mysql.com/doc/refman/5.0/en/working-with-null.html -- Postgresql & php tutorials http://www.designmagick.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
