to find the code that will let me add a user search option onto this little site that i have made, does anyone know of or have a code that will let me do this as i have been looking everywhere and even tried to write it myself but as of yet i have not had any luck lol

depends how your users are stored (mySQL databade, flatfile database, file system) and how exactly you want to search for them.

If it's SQL then we'll be able to help you much more easily

my database is in mysql and the users are stored in user id number

So if someone were to search would they have to know the id number or do you want them to be able to enter part of a username and search for that?

The reason Oberon and I are asking is because we have just finished helping a dude search his database for users beginning with a certain letter, which can be found here

Read this post from top to bottom. It will give you a good idea how WHERE cell LIKE "criteria" works, and how to use the % wildcard.

Post back if you got any problems (not the emotional or mental ones)

Using like, you can search your usernames for fragments of text by using the pattern "%fragment%" in your MYSQL LIKE clause. So "%Fred%" will match "Fred" but also "Frederick" "Frederica" "Freda" and also "MynameisFred". It's case insensitive AFAIK so it would also find fred and fReD. Not entirely certain since I haven't used this much.

I know that like is case insensitive & I believe it is the only way to search with out it being case sensitive in MYSQL. I tend to use like frequently and = much less because of the narrowness of the search results.

i had a look at the code and none of it make any sense to me