Flat file

[slimjim]

Right now I use mysql for people to register. What I want to do is prevent people from using a certain set of names I make up.

I want to put these names in a txt file and when people register. it would first read from that file if a username exist in flat file, if not then proceed to see if a user exist in the database.

If a name does exist in the flat file, well then halt the registering.

If someone can give me a example on how to start this, that would be great.

Reason is this.. I want to reserve certain user names for myself.

[Roger_Ramjet]

Keep it simple: put the names in another table then you can do the whole thing in 1 query using a nested query and NOT IN. Or just add them to the master table with a flag so the registrant bounce whether it is one of your reserved names or just someone else who beat them to it.

I can never understand why people keep on mixing flat files and complex procedures when they have all the beauty of SQL and all the power of a DBMS at their fingertips. I'm sure you can come up with all sorts of rationals as to why you 'need' to do the flat-file thing. None of them can not be more easily satisfied with a small second table.

[jannoy]

what is the purpose of creating a flat file?? for the name

[slimjim]

I did what you said roger 🙂

[Megahertza]

I would suggest adding the names to the member table, that way when it checks if a member exists it will also prevent pll from using those names