[FX.php List] Pointing Clients to correct FM DB based on login info

[Jon Montgomery]

On 8/20/06 9:09 PM, "Jonathan Schwartz" <jonathan at eschwartz.com> wrote:

> Jon,
> 
> I can whip something up for you.
> 
> Are you sure that you are using 26 different files...or do you mean 26
> different tables in one file...or better yet...one file, one table with a key
> to differentiate the different registration categories?
> 
> J
> 
> 
> At 6:18 PM -0500 8/20/06, Jon Montgomery wrote:
>> On 8/20/06 3:59 PM, "Jonathan Schwartz" <jonathan at eschwartz.com> wrote:
>>> Jon,
>>> 
>>> Do *you* know what database the registrant should be directed to?  If so,
>>> then Bob's suggestion is an easy way to go.  We also assume the the
>>> registrant is pre-registered with username and password with the target
>>> database name already populated.
>>> 
>>> HTH.
>>> 
>>> Resident Beginner,
>>> 
>>> Jonathan
>>> 
>>> 
>>> At 3:42 PM -0500 8/20/06, Bob Patin wrote:
>>>> Jon,
>>>> 
>>>> You could create a table that had the following fields:
>>>> 
>>>> username
>>>> password
>>>> database_name
>>>> 
>>>> Then, when they login (by providing a good username/password pair from the
>>>> above table in a FIND query), you'd then retrieve the database_name from
>>>> the same record.
>>>> 
>>>> Then, you could set $dbname to $database_name from the above query.
>>>> 
>>>> Then, in a 2nd query, you assign the database by using your $dbname
>>>> variable.
>>>> 
>>>> Bob Patin
>>>> Longterm Solutions
>>>> bob at longtermsolutions.com
>>>> 615-333-6858
>>>> http://www.longtermsolutions.com
>>>> 
>>>> CONTACT US VIA INSTANT MESSAGING:
>>>> AIM or iChat: longterm1954
>>>> Yahoo: longterm_solutions
>>>> MSN: tech at longtermsolutions.com
>>>> ICQ: 159333060
>>>> 
>>>> 
>>>> On Aug 20, 2006, at 3:36 PM, Jon Montgomery wrote:
>>>>> Hi,
>>>>> How do I set up a login procedure that will direct clients to one of 26 FM
>>>>> data bases? These clients belong to a pool that will attend and conference
>>>>> in various sites throughout the state. When they login, to give them
>>>>> permission to enter conference information, I would like it to direct them
>>>>> to the proper data base. I am afraid if I give them all 26 choices to
>>>>> select from on a page, they may select the wrong conference to enter their
>>>>> data.
>>>>> I have been told that this can be done, but my mind is not thinking
>>>>> outside the box, or I just don't know the box well enough to think outside
>>>>> of it yet. Any and all help will be greatly appreciated.
>>>>> I do find all of the posts very educational and have learned from them.
>>>>> Thank you for this way of QUICK FX.PHP education.
>>>>> 
>>>>> Jon Montgomery
>>>>> 
>>>>> --
>>>>> Jon W. Montgomery, Vice President and Webmaster
>>>>> Illinois Grade School Music Association - Southern Division
>>>>> Email at: vicepresident at onecliq.net
>>>>> School email at : jwmontgomery at dqud300.perry.k12.il.us
>>>>> Home phone: (618) 542-2287
>>>>> School phone: (618) 542-2646 ext. 1133
>>>>> Web Site: www.igsmasouth.org <http://www.igsmasouth.org>
>>>>> 
>>>>> If this email is spam, report it here:
>>>>> http://www.OnlyMyEmail.com/ReportSpam
>>>>> <http://www.OnlyMyEmail.com/reportSpam?Id=NDIyMTM6MTU2OTkyNzUyOmJvYkBwYXRp
>>>>> bi5jb20%3D>
>>>>> _______________________________________________
>>>>> FX.php_List mailing list
>>>>> FX.php_List at mail.iviking.org
>>>>> http://www.iviking.org/mailman/listinfo/fx.php_list
>>>>> 
>>>>> 
>>>>> 
>>>>> --
>>>>> If this email is spam, report it here:
>>>>> http://www.OnlyMyEmail.com/reportSpam?Id=NDIyMTM6MTU2OTkyNzUyOmJvYkBwYXRpb
>>>>> i5jb20%3D 
>>>>> <http://www.OnlyMyEmail.com/reportSpam?Id=NDIyMTM6MTU2OTkyNzUyOmJvYkBwYXRp
>>>>> bi5jb20%3D>
>>>> 
>>>> 
>>>> _______________________________________________
>>>> FX.php_List mailing list
>>>> FX.php_List at mail.iviking.org
>>>> http://www.iviking.org/mailman/listinfo/fx.php_list
>>> 
>> 
>> Thanks Bob and Jonathan,
>>     Jonathan, yes I do know which database they should go to.  It is for
>> school music directors and we get so busy teach the music that the
>> administrative stuff is the last thing we want to do so our tendancy is to
>> NOT READ and just do.  I am trying to make it DUMMY PROOF so they cannot make
>> a mistake because something I set up was unclear or they didn't read.
>>     Bob, this is kind of what I thought I should do, however I am still fuzzy
>> on the exact coding but will work with it and see what I can come up with.
>> 
>>     Thanks for the quick response.
>> 
>> Jon Montgomery
>> --
>> Jon Montgomery
>> Home Phone      618.542.2287
>> Work Phone      618.542.2646 ext. 1133
>> Email           vicepresident at onecliq.net
>> Email           jwmontgomery at dqud300.perry.k12.il.us
>> 
>> _______________________________________________
>> FX.php_List mailing list
>> FX.php_List at mail.iviking.org
>> http://www.iviking.org/mailman/listinfo/fx.php_list
> 

Jonathan,
    I will have to use 26 DB¹s.  Each DB will be it¹s own contest site
(music contest).  I do not have enough time to let all sites work online on
the contest day. So I will build runtime solutions for each site after
directors attending site enters their students.  I thought of the one
database with keys, but right now this seems to be the easiest for me.  This
is not my main job.
    I appreciate any help.  Thanks in advance.

Jon 
-- 
Jon W. Montgomery, Vice President and WebMaster
Illinois Grade School Music Association ­ Southern Division
Email at: vicepresident at onecliq.net
School email at : jwmontgomery at dqud300.perry.k12.il.us
Home phone:  (618) 542-2287
School phone:  (618) 542-2646 ext. 1133
Web Site:  www.igsmasouth.org

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.iviking.org/pipermail/fx.php_list/attachments/20060820/592ebdea/attachment.html