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

[Jon Montgomery]

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=NDIyMTM6MTU2OTkyNzUyOmJvYkBwYXRpbi
>>> 5jb20%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=NDIyMTM6MTU2OTkyNzUyOmJvYkBwYXRpbi5
>>> jb20%3D 
>>> <http://www.OnlyMyEmail.com/reportSpam?Id=NDIyMTM6MTU2OTkyNzUyOmJvYkBwYXRpbi
>>> 5jb20%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

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