Jason Pruim wrote:
On Mar 14, 2008, at 1:15 PM, Shawn McKenzie wrote:
Dan Joseph wrote:
I am attempting to add a little error checking for a very simple login
system. The info is stored in a MySQL database, and I am using mysqli
to connect to it. I have it working with the solution provided below,
but I am wondering if this is the right way to do it or if there is a
better way?
I don't see anything wrong with that method. One thing I would
suggest is
that you make username unique in your database if you want to avoid
duplicate results. But your way of checking is just fine as it is.
To go along with this and making sure that usernames are unique, I would
LIMIT 1 on the query. With no LIMIT, if you have 300,000 users, then
the query will not stop if it matches the first user, it searches all
300,000. With LIMIT 1 it will stop on the first match.
Hi Shawn,
I do have a LIMIT 0,1 that didn't make it into the actual copy/paste.
Thanks though for the tip!
If this is the case, then you will never have a situation where your result set
will be larger then 1. It will be either 1 or 0 (zero).
--
Jim Lucas
"Some men are born to greatness, some achieve greatness,
and some have greatness thrust upon them."
Twelfth Night, Act II, Scene V
by William Shakespeare
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
