Hi,
Monday, January 24, 2011, 10:50:41 PM, you wrote:
BP> Hi all,
BP> I have to perform a mysql query in a table with millions of records.
BP> I've full-text indexed my search field and I'm searching with MATCH AGAINST.
BP> But there is a problem. In this field there are company names that
BP> c
> -Original Message-
> From: Barbara Picci [mailto:barbara.pi...@sardi.it]
> Sent: Monday, January 24, 2011 4:51 AM
> To: php-general@lists.php.net
> Subject: [PHP] Mysql search query ignoring dots
>
> Hi all,
>
> I have to perform a mysql query in a tab
Hi all,
I have to perform a mysql query in a table with millions of records.
I've full-text indexed my search field and I'm searching with MATCH AGAINST.
But there is a problem. In this field there are company names that
contain dots, for istance I've "PO.SE. srl" and I want to find it if
the u
At 2:12 PM +0300 6/4/10, Tanel Tammik wrote:
Hello,
if there is some webpage content with html tags in database is it possible
to search it without tags?
data : 'you need some styling!'
when i now search for 'you style' i don't want to get any rows! is it
possible?
when i search 'you styling'
On Fri, 2010-06-04 at 15:00 +0300, Tanel Tammik wrote:
> "Ashley Sheridan" wrote in message
> news:1275652880.2217.54.ca...@localhost...
> > On Fri, 2010-06-04 at 14:54 +0300, Tanel Tammik wrote:
> >
> >> "Ashley Sheridan" wrote in message
> >> news:1275652342.2217.51.ca...@localhost...
> >> >
"Ashley Sheridan" wrote in message
news:1275652880.2217.54.ca...@localhost...
> On Fri, 2010-06-04 at 14:54 +0300, Tanel Tammik wrote:
>
>> "Ashley Sheridan" wrote in message
>> news:1275652342.2217.51.ca...@localhost...
>> > On Fri, 2010-06-04 at 14:44 +0300, Tanel Tammik wrote:
>> >
>> >> "As
On Fri, 2010-06-04 at 14:54 +0300, Tanel Tammik wrote:
> "Ashley Sheridan" wrote in message
> news:1275652342.2217.51.ca...@localhost...
> > On Fri, 2010-06-04 at 14:44 +0300, Tanel Tammik wrote:
> >
> >> "Ashley Sheridan" wrote in message
> >> news:1275651371.2217.46.ca...@localhost...
> >> >
"Ashley Sheridan" wrote in message
news:1275652342.2217.51.ca...@localhost...
> On Fri, 2010-06-04 at 14:44 +0300, Tanel Tammik wrote:
>
>> "Ashley Sheridan" wrote in message
>> news:1275651371.2217.46.ca...@localhost...
>> > On Fri, 2010-06-04 at 14:12 +0300, Tanel Tammik wrote:
>> >
>> >> Hel
On Fri, 2010-06-04 at 14:44 +0300, Tanel Tammik wrote:
> "Ashley Sheridan" wrote in message
> news:1275651371.2217.46.ca...@localhost...
> > On Fri, 2010-06-04 at 14:12 +0300, Tanel Tammik wrote:
> >
> >> Hello,
> >>
> >> if there is some webpage content with html tags in database is it
> >> po
"Ashley Sheridan" wrote in message
news:1275651371.2217.46.ca...@localhost...
> On Fri, 2010-06-04 at 14:12 +0300, Tanel Tammik wrote:
>
>> Hello,
>>
>> if there is some webpage content with html tags in database is it
>> possible
>> to search it without tags?
>>
>> data : 'you need some stylin
On Fri, 2010-06-04 at 14:12 +0300, Tanel Tammik wrote:
> Hello,
>
> if there is some webpage content with html tags in database is it possible
> to search it without tags?
>
> data : 'you need some styling!'
>
> when i now search for 'you style' i don't want to get any rows! is it
> possible?
Hello,
if there is some webpage content with html tags in database is it possible
to search it without tags?
data : 'you need some styling!'
when i now search for 'you style' i don't want to get any rows! is it
possible?
when i search 'you styling' i get the row!
Br
Tanel
--
PHP General
At 11:16 PM -0700 10/21/08, Ryan S wrote:
Am hoping someone out there can recommend a better script or maybe
share some of your own code?
Any help would be appreciated.
Do it right... read up on MySQL's fulltext matching.
Cheers,
Rob.
Did some searching based on your tip, got what i w
> Am hoping someone out there can recommend a better script or maybe share some
> of your own code?
>
> Any help would be appreciated.
Do it right... read up on MySQL's fulltext matching.
Cheers,
Rob.
Did some searching based on your tip, got what i was looking for, just didnt
know wher
On Tue, 2008-10-21 at 21:48 -0700, Ryan S wrote:
> Hey all,
> I have two columns in my DB
> title varchar(254)
> and
> jtext text
>
> which I would like to search, as the user might enter two or more words I am
> opting not to use LIKE %search_term% so started searching google, I came
> acros
Hey all,
I have two columns in my DB
title varchar(254)
and
jtext text
which I would like to search, as the user might enter two or more words I am
opting not to use LIKE %search_term% so started searching google, I came across
this very promising class:
http://code.activestate.com/recipes/12
* Thus wrote Robb Kerr ([EMAIL PROTECTED]):
>
> I'm always getting an error when testing the page. The error is...
>
> Parse error: parse error, expecting `T_VARIABLE' or `'$'' in
> /home/s/k/user992816/html/RobesonWeb/TMP4np9nf7zp.php on line 4
>
> The line to which it refers is the line statin
That was it! Thanx for the help. This board has proven invaluable to me.
Robb
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
The line should be
$vManufacturer_rs_RobesonResultsList = (get_magic_quotes_gpc()) ?
$manufacturer : addslashes($manufacturer);
Robb Kerr wrote:
Newbie question - please excuse. I'm using Dreamweaver to generate most of
my PhP. I have created a search page and am trying to generate the results
pa
[snip]
if (isset(manufacturer)) {
$vManufacturer_rs_RobesonResultsList = (get_magic_quotes_gpc()) ?
manufacturer : addslashes(manufacturer);
}
Parse error: parse error, expecting `T_VARIABLE' or `'$'' in
/home/s/k/user992816/html/RobesonWeb/TMP4np9nf7zp.php on line 4
[/snip]
Looks like 'manufac
Newbie question - please excuse. I'm using Dreamweaver to generate most of
my PhP. I have created a search page and am trying to generate the results
page. The search form is using the GET function and the form field name is
"manufacturer". The following code is generated by DW in the results
page.
>I am currently working on a website that is implemented using PHP and MySQL.
>
>The site currently has a simple search engine that allows a shopper to type
>in a search string that is stored in $search. For example, if a shopper
>types in 1972 Ford Mustang
>$string ="1972 Ford Mustang"
>
>Using t
; <[EMAIL PROTECTED]>
To: "PHP PHP" <[EMAIL PROTECTED]>
Sent: Saturday, July 27, 2002 9:31 PM
Subject: [PHP] PHP/MySQL Search Engine Query Question
> I am currently working on a website that is implemented using PHP and
MySQL.
>
> The site currently has a simple sear
exes (refer to the MySQL manual).
-Naintara
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
t]On Behalf Of Paul Maine
Sent: Sunday, July 28, 2002 8:02 AM
To: PHP PHP
Subject: [PHP] PHP/MySQL Search Engine Query Question
I am currently working on a website that is implem
I am currently working on a website that is implemented using PHP and MySQL.
The site currently has a simple search engine that allows a shopper to type
in a search string that is stored in $search. For example, if a shopper
types in 1972 Ford Mustang
$string ="1972 Ford Mustang"
Using the follo
-
From: Lizlynch <[EMAIL PROTECTED]>
Newsgroups: php.general
To: <[EMAIL PROTECTED]>
Sent: Friday, September 07, 2001 6:59 PM
Subject: php/mysql search. need help
i have a form where a user inputs a home service type and this results in a
list of that value, eg a user inputs &
i have a form where a user inputs a home service type and this results in a list of
that value, eg a user inputs 'plumber' and a list of plumbers is displayed.
if a user accidentally types plumbar no results are displayed.
is there anyway of making php/mysql recognise the first three letters or
Hi Jason,
Say you have a search form that says search for "searchbox" and the search
box has a variable name of "search":
NO Valid search results.
">
1) {
echo "Previous";
}
if (($num > 25) && (($limit + 25) < $num)) {
echo "Next.";
}
/* End the initial "Else" */
}
?>
___
In a MySQL query you can use the LIMIT keyword, like in phpmyadmin.
Use limit 0,10 to get the first ten results in a query.
Then do the query again but use 10,10 for the limit.
The first number is the "offset", and the second one is the maximum results
to return.
That's the way most people do
Does anyone know (or have) of a good example of how to create search results
like a Yahoo or MSN search?
for example:
Say I do a search for "cars" and there are 10,000 records in my table that
match "car"... I would like to show the results in blocks of (say) 25 at a
time, therefore I will need
Hi there..
Try:
SELECT HouseID FROM Search WHERE (CountryID='2' AND PriceID='3' OR
(FacilityID='1' OR FacilityID='5'))
The extra brackets are only to make it easier to read.. (For me it is..)
What you basically asked where all records in which CountryID is 2 and
PriceID is 3 AND (only) where t
Hya'll,
I've got a little problem with coding some php/mysql, this is what I have :
-
Table Search
-
HouseID | FacilityID | SurroundingID | PriceID | TypeID | C
> if ($search_in == "1"){
>$query1 = "SELECT * FROM FISH where ID LIKE '%$search_text%'
> OR name LIKE '%$search_text%' OR Category LIKE '%$search_text%' OR Color
> LIKE '%$search_text%' OR Size LIKE '%$search_text%'";
> }
Looks good the way it is for now.
Things you *could* do:
1) Break up
I got this from a book but given the fact that it would only search for
one type of information I modified it and it works great, but I wanted
to know what you think about it if anything. Could an array be maid to
trim it down?
if ($search_in == "1"){
$query1 = "SELECT * FROM FISH where ID L
34 matches
Mail list logo
