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!


>
>
> -Shawn
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>

--

Jason Pruim
Raoset Inc.
Technology Manager
MQC Specialist
3251 132nd ave
Holland, MI, 49424-9337
www.raoset.com
japruim@raoset.com