> Would someone show me a sample query from the table? I have tried to
> get this to work during the past half hour and I don't understand this
> type of query yet.
>
> Where I am at with my search query that doesn't work is:
>
> SELECT MATCH ( 'product_description_search') AGAINST ( 'Jesus')
> You can't create a multi-col full text index. You should only create it
> on the long text field
'Course you can.
mysql> create table a(a int, b varchar(50), c text);
Query OK, 0 rows affected (0.01 sec)
mysql> create fulltext index fulltext_bc on a(b,c);
Query OK, 0 rows affected (0.01 sec)
Ok. I have the index created.
ALTER TABLE `shopping_cart_product` ADD FULLTEXT
( `product_description`,`product_name` )
is what worked --- I think the web site
http://dev.mysql.com/doc/refman/5.0/en/create-index.html was assuming
the creation of a new table.
I am able to have both columns i
On 5/30/08, Ron Piggott <[EMAIL PROTECTED]> wrote:
>
>
> I don't understand what is going wrong:
>
> CREATE FULLTEXT INDEX
> ON shopping_cart_product(product_name, product_description)
>
> gives me this error:
>
> #1064 - You have an error in your SQL syntax; check the manual that
> corresponds
I don't understand what is going wrong:
CREATE FULLTEXT INDEX
ON shopping_cart_product(product_name, product_description)
gives me this error:
#1064 - You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use
near 'ON ï»
Ron Piggott wrote:
> I am getting the following error when running the query through php my
> admin:
>
> MySQL said: Documentation
>
> #1191 - Can't find FULLTEXT index matching the column list
Grr - stupid manual didn't have a link on how to create the index.
http://dev.mysql.com/doc/refman/5.
I am getting the following error when running the query through php my
admin:
MySQL said: Documentation
#1191 - Can't find FULLTEXT index matching the column list
I am new to this; Thank you for the help.
Ron
On Wed, 2008-05-28 at 22:01 -0400, Ron Piggott wrote:
> Someone referred me to:
>
Ron Piggott wrote:
> Someone referred me to:
>
> http://dev.mysql.com/doc/refman/5.0/en/fulltext-search.html
>
> Does this look like I am on the right track?
>
> Ron
>
> SELECT MATCH(shopping_cart_product.product_description,
> shopping_cart_product.product_name) AGAINST ('$keyword') as Releva
Someone referred me to:
http://dev.mysql.com/doc/refman/5.0/en/fulltext-search.html
Does this look like I am on the right track?
Ron
SELECT MATCH(shopping_cart_product.product_description,
shopping_cart_product.product_name) AGAINST ('$keyword') as Relevance
FROM ( shopping_cart_category INNER
Thanks Chris,
By the way do you have problems with spammers getting your gmail address
from usenet?
The user_id is actually what I'm searching for dynamically, so my initial
query was relatively correct as it returns one row with user 1.
However, I wasn't familiar with the concept of self-join
you must have three tables
user (have at least user_id field)
group (have at least groupd_id field)
user_group (have 2 fields: user_id and group_id, you can also have
user_group_id - depends on your need)
/* if you only need the user id */
select user_id from user_group where group_id in (1,2);
Steve McGill wrote:
Hello,
I am trying to find out how to search a many-to-many map table efficiently.
I have an example table:
user,user_group
1,1
1,2
2,1
3,2
I want to find out all the users who are a member of BOTH groups 1 AND 2. In
this example, this would just be the user with id 1.
Hello,
I am trying to find out how to search a many-to-many map table efficiently.
I have an example table:
user,user_group
1,1
1,2
2,1
3,2
I want to find out all the users who are a member of BOTH groups 1 AND 2. In
this example, this would just be the user with id 1.
Until now, I can either
eregi_replace or str_replace can do that for you
Bastien
From: "Ron Piggott (PHP)" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: PHP DB
Subject: [PHP-DB] Searching PHP strings
Date: Thu, 28 Sep 2006 21:12:18 -0400
I have been playing tonight for a few minutes.
Th
I have been playing tonight for a few minutes.
The following code:
Produces me output like:
137
http://www.actsministrieschristianevangelism.org/christianliving/quiet_time_quotations_and_reflection_topics.html";>here.
What I want to do now is to remove the
http://www.actsministrieschristia
Ron Piggott (PHP) wrote:
If $file_name includes the path
/path/to/file/file_name.pdf
is there anyway of searching from the right hand side to the left and
getting the file name out the $file_name variable? The file name starts
the character following the last /
http://www.php.net/pathinfo will
If $file_name includes the path
/path/to/file/file_name.pdf
is there anyway of searching from the right hand side to the left and
getting the file name out the $file_name variable? The file name starts
the character following the last /
Ron
you could probably use curl to grab the source for the page then use a regex
to see if your domain is found maybe something like
if(preg_match("/www\.domain\.com/is")) // match found
else // not found
dont quote me on the regex as i am not very good with regex, also you would
want a button in the
I have a web site and google likes to count the inbound links. I have set
up a way for people to add links from my site to theirs, however I would
like to check whether they have linked back to my site. I ask them to
nominate where the link back page is, and I could check this manually. But
Aravalli Sai wrote:
hi
i had designed an inventory management system where
in i can ADD,INSERT,DELETE,UPDATE the data
elements..but when i am trying to find(search) an
entry in theinventory data base system (i want to find
the entrybased on the "tagno" since this is the
primary key in my table) t
[EMAIL PROTECTED]
Subject: [PHP-DB] searching an entry in inventory db
Date: Sat, 4 Dec 2004 10:14:52 -0800 (PST)
hi
i had designed an inventory management system where
in i can ADD,INSERT,DELETE,UPDATE the data
elements..but when i am trying to find(search) an
entry in theinventory data base sys
hi
i had designed an inventory management system where
in i can ADD,INSERT,DELETE,UPDATE the data
elements..but when i am trying to find(search) an
entry in theinventory data base system (i want to find
the entrybased on the "tagno" since this is the
primary key in my table) the logic i had writt
stristr();
http://us2.php.net/stristr
-Micah
On Sun January 11 2004 8:29 pm, Rick wrote:
> Hi all,
> Does anyone have a class or function that can be used to search any
> given string from a textfield ie:
>
> $string = london rome paris...
>
> Thanks in advance!
>
>
> R
--
PHP Database M
Hi all,
Does anyone have a class or function that can be used to search any
given string from a textfield ie:
$string = london rome paris...
Thanks in advance!
R
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
I currently manage a MySQL database with about 3 records. I've given my users the
ability to search the name field by pattern.
For example, the name field can hold 36 characters and contains first name, middle
initial and last name. example:
NAME
John D Miller Jr.
Harry B Davis
Angela De L
> -Original Message-
> From: Jamie Saunders [mailto:[EMAIL PROTECTED]
> Sent: 16 July 2003 11:20
>
> Hi, I need a way of searching a file for text between two
> brackets, below
> is an example of a couple of lines from the file I'm searching:
>
> {L_LOGIN}
> {L_LOGOUT}
>
> So I'll need
Hi, I need a way of searching a file for text between two brackets, below
is an example of a couple of lines from the file I'm searching:
{L_LOGIN}
{L_LOGOUT}
So I'll need to search the above for text between the '{' and '}' brackets
and read each into an array.
--
Jamie Saunders
Media Architec
rator
Trilogy International, Inc
http://www.trilogyintl.com/ecommerce/
---
-Original Message-
From: Mike Delorme [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 30, 2002 11:54 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Searching DB and Printing Re
"Mike Delorme"
cc:
Subject: [PHP-DB] Se
Hi,
I have a table in DB Music that looks a little mike this:
TABLE NAME
_
SONG NAMESONG LYRICS
| | | |
| | | |
|
Hi All!
I'm searching for Datagrid component for php and mysql. Something like java
ones.
Does anyone knows one?
Thanks
Paolo
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
in ym search page, i construct a sql query from user input to search my
database, and i run this query to get totalresults. Then run another query
with a LIMIT 0, 30 ending for each page. So I'm running 2 mySQL queries per
page. My question is, is this inefficient? is there any better way i dont
k
Is there any way to search *every*thing in my database (using mysql)? I
am thinking of a query somethng like "select * from * where * LIKE
'%putsearchhere%'". This would help a lot when searching for
inappropriate language.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe,
Iv been trying to find an open source software that would calculate the
number of data retrievals (from certain fixed IPs)from MySQL database. Any
idea where I could find such a script?
Henri
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub
: "Chris Payne" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, March 20, 2002 6:58 AM
Subject: Re: [PHP-DB] Searching results of results
> Hi there,
>
> Thanks for your help on this it's appreciated, i'll look into temporary
> tables tomorrow
Hi there,
Thanks for your help on this it's appreciated, i'll look into temporary
tables tomorrow and see what I can do. Just curious, why is the method you
have shown below better than the method I used previously? Is it a speed
thing or is it more logical? I am learning different methods of
You could select these results into a temporary table
and then query that table. Look at the mysql.com docs
and check out the CREATE TEMPORARY TABLE. You can
select data right into the table and the table is
erased when the connection closes.
But first it looks like cleaning up your query would
Hi there everyone,
Say I do a simple search as follows:
$query = "SELECT * FROM search WHERE
(description LIKE '%$test%' OR state LIKE '%$test%' OR city LIKE '%$test%' OR fname
LIKE '%$test%') AND (category = '$category' AND country = '$country' AND type =
'$type') ORDER BY city ASC LIMIT $of
How would I go about doing this.. I tried to search within a MS Word
document, but that didn't work too well, since Word is not ASCII formatted,
but on the other hand, I wasn't able to search a text document created in
notepad or exported from word to a text file.
Anyway how to do this?
--
P
Gee Jason You always come up with these great and inspiring replies!
Well, I figured it out how to search within a column, but not within a text
document.
But, This isn't the solution I really am looking for. I want the ability to
search within a text document that resides on the server in a sp
On Sunday 10 February 2002 00:58, Todd Williamsen wrote:
> What I am doing is user inputs their contact information, then copies and
> pastes text and also uploads a formal document, which the location is
> stored in the database.
>
> Now, the text that gets pasted into the text field is then stor
What I am doing is user inputs their contact information, then copies and
pastes text and also uploads a formal document, which the location is stored
in the database.
Now, the text that gets pasted into the text field is then stored into the
database for search purposes.
This is the problem...
So that statement would actually open up the MS Word document and search
it for the keywords specified?
-Original Message-
From: Dan Brunner [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 08, 2002 9:34 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Searching
Hello!!!
Use LIKE in your Select statement...Like this!!
$sql = "Select File_Name From Table2 WHERE File_Name LIKE '%$Search%'";
$Search would come from a form...
Dan
On Friday, February 8, 2002, at 09:06 AM, [EMAIL PROTECTED] wrote:
> I was wondering if there is a way to search documents
I was wondering if there is a way to search documents.
Scenario:
I have a application where it uploads MS Word documents to a server and
holds the documents location in the database. What I want is to be able to
search those Word documents via keywords.
Is this possible with PHP?
--
PHP Da
escape me at the moment and i haven't got
around to implementing a decent search engine yet :)
// -Original Message-
// From: Chris Payne [mailto:[EMAIL PROTECTED]]
// Sent: Thursday, 17 January 2002 10:34 AM
// To: [EMAIL PROTECTED]
// Subject: [PHP-DB] Searching a variable
//
Hi there everyone,
Thanks for all the help recently everyone, it's very appreciated. I just have one
last question if that's ok :-)
I have a string taken from a form, now this string could contain 1 word or it would
contain 10, what I need to know is how do I search a DB for each word in the
full-text index that field in MySQL, - then query ordered by weight with
a limit 3. Wonderful stuff.
-Original Message-
From: dean james
Sent: Sat 11/10/2001 7:27 PM
To: [EMAIL PROTECTED]
Cc:
Subject: [PHP-DB] searching for
hello,
I want to create a database search with php/mysql that searches for zipcodes
in a database. of course, there will be other columns/tables and such to be
printed, but I only want to search for the zipcodes and have the other cells
printed if the following criteria are found:
lets say I s
"Jason Wong" <[EMAIL PROTECTED]> wrote in message
news:000301c1428d$f11b3a80$[EMAIL PROTECTED]...
> The obvious first thing to do is to screen your keywords. Do not search on
> common words such as:
>
> and, if, the, in etc.
An easy way to do this is to set up an array of words
to exclude. Then
tern, if so, do a
> search on REGEXP on the mySQL manual: http://www.mysql.com/doc/. I'm sure
> they have examples on using REGEXP.
>
> Good Luck.
>
> -Original Message-
> From: Jordan Elver [mailto:[EMAIL PROTECTED]]
> Sent: Friday, September 21, 2001 9:03
Just an idea...
You could do a str_replace(), replacing " max " with
max
You may need to use a reg-exp replace function to determine where actual
words are like max, vs. substrings like maximus.
see http://www.php.net/manual/en/function.str-replace.php for more info...
-Jason Garber
Lead Pr
you could probably use a str_replace() www.php.net
$description1 = "Episode 1 - Joey eats all of the food
in the house";
Suppose the search term is "food" - just go thru and
replace "food" with "food" or whatever tags you
want to use.
olinux
--- Matt C <[EMAIL PROTECTED]> wrote:
> I have summar
I have summaries of episodes stored in a database. How on earth do I go
about highlighting keywords? I mean I have done a search and it gives a list
of urls:
episodes.php?id=4&highlight=max
But how do I get it to go through all the words and highlight "max" or
whatever keyword it is??
__
I have a database in mysql that only has one table, that table has approx 25
fields . I need to be able to search for data under each of these
fields.
Field examples: Company, TechContact, AdminContact, Mobile etc etc
I need I guess a pull down menu that would select a field (c above) then
Message-
From: Devon [mailto:[EMAIL PROTECTED]]
Sent: 04 September 2001 02:15
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Searching database tables
I have a database in mysql that only has one table, that table has approx 25
fields . I need to be able to search for data under each of these
fields
I have a database in mysql that only has one table, that table has approx 25
fields . I need to be able to search for data under each of these
fields.
Field examples: Company, TechContact, AdminContact, Mobile etc etc
I need I guess a pull down menu that would select a field (c above) then
Hi Devon!
Take a look in the PHP documentation in the function reference for mysql
function.
There you'll find a set of function for connecting to the database and doing
SQL - Querys over the database. If you are not famular with SQL (SELECT -
Statements)
you have to learn :)
bye Marcus
"Devon"
I have a database of only about 25 fields written in MYSQL for our internal
client database, I need to be able to search each off these fields using
php, can some one help or point me in the correct direction?
"Doug Semig" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTE
Yes.
If you have a specific question, please post it and I'm sure folks will be
willing to try to help you out.
Doug
At 12:50 PM 9/3/01 +1000, Devon wrote:
>As per topic anyone know how to do it?
>
>Cheers
--Doug's Signature File
~ ~ ~ I'm proud to work
As per topic anyone know how to do it?
Cheers
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
61 matches
Mail list logo