Re: [PHP] Re: find (matching) person in other table



Jared Farrish wrote:
On 5/30/07, Afan Pasalic <afan@xxxxxxxx> wrote:
email has to match "in total". sales@xxxxxxxxxxxx and info@xxxxxxxxxxxx
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)?
'cause some members can be added to database by administrator and maybe they don't have email address at all. or several memebers can use the same email address (sale@xxxxxxxxxxxxxxx) and then macthing last name is kind of "required". that's how it works now and can't change it.

Consider, as well, that each time you're calling a database, you're slowing
down the response of the page. So, while making a bunch of small calls might
not seem like that much, consider:

||||||| x |||||||
||||||| a |||||||
||||||| b |||||||

Versus

||||||| x, a, b |||||||

The letters represent the request/response data (what you're giving to get,
then get back), and the pipes (|) are the overhead to process, send, receive
(on DB), process (on DB), send (on DB), receive, process, return to code.

The overhead and latency used to complete one request makes it a quicker,
less "heavy" operation. If you did the first a couple hundred or thousand
times, I would bet your page would drag to a halt while it loads...
agree. now, I have to figure it out HOW? :-)

I was looking at levenshtein, though, I think the richard's solution is just enough:

select member_id, first_name, last_name, email, ..., (5*(first_name='$first_name) + 2*(first_name='$first_name')) as score
from members
where score > 0

though, I'm getting error: "Unknown column 'score' in where clause"?!?

thanks jared.
.

Relevant Pages

  • Re: [PHP] Re: find (matching) person in other table
    ... Jared Farrish wrote: ... 'cause some members can be added to database by administrator and maybe ... > The letters represent the request/response data (what you're giving to ... > then get back), and the pipes are the overhead to process, send, ...
    (php.general)
  • Re: [PHP] Re: find (matching) person in other table
    ... Jared Farrish wrote: ... 'cause some members can be added to database by administrator and maybe ... > The letters represent the request/response data (what you're giving to ... > then get back), and the pipes are the overhead to process, send, ...
    (php.general)
  • Re: [PHP] Re: find (matching) person in other table
    ... Use a sub-query in MySQL 4.mumble or higher, ... The letters represent the request/response data (what you're giving ... then get back), and the pipes are the overhead to process, send, ... from members ...
    (php.general)
  • Re: Globally accessible variables and functions?
    ... So then what's the difference between a singleton class, ... > I fill in some values of a few data members in the newfunction - so ... > there's that overhead, performance-wise. ... > Public Shared Function CreateAs clsMyApplication ...
    (microsoft.public.dotnet.languages.vb)