Re: Re: find (matching) person in other table

On 5/30/07, Afan Pasalic <afan@afan.net> wrote: email has to match "in total". sales@abc-comp.com and info@abc-comp.com

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 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... -- Jared Farrish Intermediate Web Developer Denton, Tx Abraham Maslow: "If the only tool you have is a hammer, you tend to see every problem as a nail." $$