Thank you for the heads up on using like.  I was wondering since there will
be 2 similar variables from each page var1 var2 (identical except for the
number).  I programmed in DataFlex for about 6 years back in the late 80's
early 90's but have not done anything db wise in over 8 years....  I still
do not know where the problem was (maybe syntax or spelling....)

Again, thank you for all of your help...


"Kurt Lieber" <[EMAIL PROTECTED]> wrote in message
> On Wednesday 31 October 2001 02:32 am, you wrote:
> > So, I'd recommend giving that a try.  From my understanding (limited) of
> > MySQL, use = in the case of $id=2, and LIKE in the case of firstName
> > LIKE "justin".
> Um...you *can* do that, but I don't think you want to.  Using LIKE means
> MySQL has to do a lot more searching on all your database records.
> of searching for an exact match, where it can look at things like string
> length, first characters and other simple criteria, it now has to evaluate
> the entire contents of the field in case there's a possible match
> in the string.  Much, much slower.
> So, yes it works, but you pay a performance price for it.
> --kurt

PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to