NYCPHP Meetup

[Daniel Kushner]

http://www.zend.com/phpfunc/a.php

-Daniel
 

> -----Original Message-----
> From: talk-bounces at lists.nyphp.org 
> [mailto:talk-bounces at lists.nyphp.org] On Behalf Of jessica kelly
> Sent: Friday, May 21, 2004 10:15
> To: talk at lists.nyphp.org
> Subject: [nycphp-talk] New Functions on old PHP
> 
> Hi,
> 
> I have an script that was written after PHP 4.0.5 and wish to 
> figure out what functions need to be worked around to get it 
> to work on the 4.0.5 server. 
> 
> Other than checking the functions one by one on the function 
> / PHP version table at php.net, is there a tool out there 
> that would do it for me?
> 
> TIA,
> 
> Jessica
> 
> 
> 
> _______________________________________________
> talk mailing list
> talk at lists.nyphp.org
> http://lists.nyphp.org/mailman/listinfo/talk
> 
> 
> 



>From hans not junk at nyphp.com  Fri May 21 13:18:50 2004
Return-Path: <hans not junk at nyphp.com>
Received: from ehost011-1.intermedia.net (ehost011-1.intermedia.net
	[64.78.21.3]) by virtu.nyphp.org (Postfix) with ESMTP id A24FDA860A
	for <talk at lists.nyphp.org>; Fri, 21 May 2004 13:18:50 -0400 (EDT)
X-MimeOLE: Produced By Microsoft Exchange V6.5.6944.0
Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Subject: RE: [nycphp-talk] MySQL 4.0.10 Fulltext Search Relevancy Problem
Date: Fri, 21 May 2004 10:18:46 -0700
Message-ID: <41EE526EC2D3C74286415780D3BA9F8702108DE6 at ehost011-1.exch011.intermedia.net>
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
Thread-Topic: [nycphp-talk] MySQL 4.0.10 Fulltext Search Relevancy Problem
Thread-Index: AcQ/Pub97CCcoYWTScuBbjz/KvDR1wAGFOUw
From: "Hans Zaunere" <hans not junk at nyphp.com>
To: "NYPHP Talk" <talk at lists.nyphp.org>
X-BeenThere: talk at lists.nyphp.org
X-Mailman-Version: 2.1.4
Precedence: list
Reply-To: NYPHP Talk <talk at lists.nyphp.org>
List-Id: NYPHP Talk <talk.lists.nyphp.org>
List-Unsubscribe: <http://lists.nyphp.org/mailman/listinfo/talk>,
	<mailto:talk-request at lists.nyphp.org?subject=unsubscribe>
List-Archive: <http://lists.nyphp.org/pipermail/talk>
List-Post: <mailto:talk at lists.nyphp.org>
List-Help: <mailto:talk-request at lists.nyphp.org?subject=help>
List-Subscribe: <http://lists.nyphp.org/mailman/listinfo/talk>,
	<mailto:talk-request at lists.nyphp.org?subject=subscribe>
X-List-Received-Date: Fri, 21 May 2004 17:18:51 -0000


>     SELECT
>     image.id, image.image_name,
>     (MATCH (image_name, image_alt, image_location_city,
>     image_location_state, image_location_country) AGAINST ('test')
>     OR MATCH (first_name, last_name) AGAINST ('test')
>     OR MATCH (keyword_name) AGAINST ('test')
>     OR MATCH (event_name) AGAINST ('test')
>     OR MATCH (placement_name) AGAINST ('test')
>     ) as score,
>     image.image_path, image.image_creation_date
>     FROM image

...

> Using this query I always get a relevancy score of 1 every=20
> time; I do not actually get the floating-point decimal number=20
> that I was seeking (the accurate relevancy); this based on=20

This is because of your MATCH statements.  Because you are doing OR,
it's a logical operator, and thus:

1 OR 1 OR 1 =3D 1

I think you need to revisit your query and possibly break it into
multiple queries.

H