Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-08-31 : 10:39:23
|
Alex writes "Hi,
This is a question that has me a bit stumped. I want a user to login and on the main page see recent entries from other users matching the logged in user's state/province.
The only way I can see of doing this is just created listings upon listings of Province name from all the countries in the world and just relate them to eachother via a number.
Now the other thing I was thinking of, which will be a better approach is just relate it to the text entries from the province name in the registratuion area...but then I am faced with the problem that if a user does not enter the same information as the other they won't see new entries, or at least some new entries that have been made by other users.
Recap.
User is registered as being in County Galway. I want this user to see new entries for County Galway from all other users.
Problem
What if user A Specified Co. Galway instead County Galway and User B specified Galway, then those entries will not be able to be related.
Also this has to work no matter which province or state in which country is specified by the user.
Any ideas will be highly appreciated,
Thanks!"
|
|
|
|
|
|
Country and Areas