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 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." $$
