core > 0
>
>
>> -Original Message-
>> From: Richard Lynch [mailto:[EMAIL PROTECTED]
>> Sent: Thursday, May 31, 2007 3:42 PM
>> To: Afan Pasalic
>> Cc: Jared Farrish; php-general@lists.php.net
>> Subject: Re: [PHP] Re: find (matching) person
; > from members
HAVING score > 0
> -Original Message-
> From: Richard Lynch [mailto:[EMAIL PROTECTED]
> Sent: Thursday, May 31, 2007 3:42 PM
> To: Afan Pasalic
> Cc: Jared Farrish; php-general@lists.php.net
> Subject: Re: [PHP] Re: find (matching) person i
MySQL doesn't let you use the calculated values (score) in the where
clause.
PostgreSQL does, as I recall.
Sorry.
You may be able to get around that with:
Do a GROUP BY on something unique, so the GROUP BY is pointless, but
then you can use HAVING score > 0
Use a sub-query in MySQL 4.mumble or
David Giragosian wrote:
On 5/31/07, Afan Pasalic <[EMAIL PROTECTED]> wrote:
Jared Farrish wrote:
> On 5/30/07, Afan Pasalic <[EMAIL PROTECTED]> wrote:
> email has to match "in total". [EMAIL PROTECTED] and
[EMAIL PROTECTED]
>> are NOT the same in my case.
>>
>> thanks jared,
>
> If you can
On 5/31/07, Afan Pasalic <[EMAIL PROTECTED]> wrote:
Jared Farrish wrote:
> On 5/30/07, Afan Pasalic <[EMAIL PROTECTED]> wrote:
> email has to match "in total". [EMAIL PROTECTED] and [EMAIL PROTECTED]
>> are NOT the same in my case.
>>
>> thanks jared,
>
> If you can match a person by their ema
Jared Farrish wrote:
On 5/30/07, Afan Pasalic <[EMAIL PROTECTED]> wrote:
email has to match "in total". [EMAIL PROTECTED] and [EMAIL PROTECTED]
are NOT the same in my case.
thanks jared,
If you can match a person by their email, why not just SELECT by email
only
(and return the persons in
Hello Afan & list,
I recently coded such an animal for a customer. It is a quick and dirty piece
of work. They had an existing dataset and wanted to match new registrants
against the dataset so as to avoid duplication. First we applied logic to not
accept duplicate email addresses in the registr
On 5/30/07, Afan Pasalic <[EMAIL PROTECTED]> wrote:
email has to match "in total". [EMAIL PROTECTED] and [EMAIL PROTECTED]
are NOT the same in my case.
thanks jared,
If you can match a person by their email, why not just SELECT by email only
(and return the persons information)?
Consider, as
Jared Farrish wrote:
On 5/30/07, Afan Pasalic <[EMAIL PROTECTED]> wrote:
yes. in one hand it's more for mysql list. though, I was thinking more
if somebody had already something similar as a "project". more as path I
have to follow.
e.g., in your example, in where clause AND doesn't work bec
On 5/30/07, Afan Pasalic <[EMAIL PROTECTED]> wrote:
yes. in one hand it's more for mysql list. though, I was thinking more
if somebody had already something similar as a "project". more as path I
have to follow.
e.g., in your example, in where clause AND doesn't work because bob
could be robert
Jared Farrish wrote:
I was thinking to assign points (percentage) to matching fields (last
name, first name, email, phone, city, zip, phone) and then list people
with more than 50%. e.g., if first and last name match - 75%, if only
email match - 85%, if first name, last name and email match - 100
On 5/30/07, Jared Farrish <[EMAIL PROTECTED]> wrote:
$lastname = strpos('Rogers',0,2);
$firstname = strpos('Timothy',0,2);
$select = "SELECT `uid`,`LastName`,`FirstName`
FROM `users`
WHERE LastName='$lastname%'
AND FirstName='$firstname%'";
Stri
I was thinking to assign points (percentage) to matching fields (last
name, first name, email, phone, city, zip, phone) and then list people
with more than 50%. e.g., if first and last name match - 75%, if only
email match - 85%, if first name, last name and email match - 100%, if
last name and ph
13 matches
Mail list logo