I am looking to make a member directory for an organization on the website.

Please let me know if this is a bad use of Links SQL or if I am on the right path :-)

I was planning on using the "Registered Users" option and adding the field "State". I would like to be able to make this a pull down option with all the states in the US on the pull down. Then have registered users the ability to navigate through the directory and be able to contact users in there state etc....

Also, is there a way to mail the registered Users, it appears that there is just a way to mail link owners?

I'm new to this SQL stuff, not sure if this is an easy task or not, thought I would ask the pro's. Thanks

I created two extra tables...Country and State and each of these tables contain records of countries and states. Then I hacked DB_Utils.pm to create drop-down menus from the Country and State tables.
I also hacked the user.cgi to call the subs I've added in the DB_Utils.pm.

To see this in action, go to:

http://vlib.anthrotech.com/bin/user.cgi

Then click on Register Account link.

If you view the SOURCE of the document, you will see that there are two fields called State and Country with different ID values. I have added State and Country in my Users table, but the value of these fields are pulled from the State and Country tables...very similar to how Category IDs are pulled into the Links table.

Regards,

Eliot Lee

You must be working on it, but just in case you aren't:

http://www.postcards.com
FAQ: http://www.postcards.com/FAQ/LinkSQL/

Thank you, Robert...it is working now...in case anyone is interested...

Regards,

Eliot Lee