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

[Jonathan Schwartz]

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=NDIyMTM6MTU2OTkyNzUyOmJvYkBwYXRpbi5jb20%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=NDIyMTM6MTU2OTkyNzUyOmJvYkBwYXRpbi5jb20%3D 
><http://www.OnlyMyEmail.com/reportSpam?Id=NDIyMTM6MTU2OTkyNzUyOmJvYkBwYXRpbi5jb20%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 Schwartz
FileMaker 8 Certified  Developer
Associate Member, FileMaker Solutions Alliance
Schwartz & Company
jonathan at eschwartz.com
http://www.eschwartz.com
http://www.exit445.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.iviking.org/pipermail/fx.php_list/attachments/20060820/2e3c0e3a/attachment.html