I have a mysql database with 99 people.

The first column on db is call id and assigns a diferent 4 digit number to each person. Second column contains each person`s complete name....

someone tells me i need an adittional user column to asign a username to each person...(cause i want a login page) but since i already have a different name and a different id for everybody, why would i need a such column?

can someone please tell me how can i use this 2 columns (name and id) so they can type their complete 4 digit id and just part of their name to enter through a login page (i dont want them to type their complete name, just part of it, and theit complete id.


can this be done with php? or its related to mysql?

Enabling people to just type a part of their name means more scripting to process the form because you're not looking for an exact match. It also means that people will be able to guess login details more easily because the form isn't applying as strict controls. And usually login names are unique which won't be the case if you allow people to enter just part of their name (e.g. if you have 2 people named John).

If you find out, would you object to telling me which php script you are using? I kind of need the same sort of database for a website.

Thanks!

what does that mean a mysql data with 99 people..

Oh..i'm faint of that.

i just use the cpanel for this things.

A database used to log certain bits of information about an executed script has 99 users on it. Basically, it's like a server-side list of users of your site upon other things which you can tell your site to use to, say, let someone log in. It's within the cPanel under the databases section.

That was a bad description, sorry :/