Amy,

There are SEVERAL things I have tried to get this to work without replication of the DB's.

The problem is that there is more than just userid and password involved in the treads.

<pre> <PRE>
+----------------+------------------+------+-----+-----------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------------+------------------+------+-----+-----------+----------------+
| U_LoginName | varchar(64) | | MUL | | |
| U_Username | varchar(64) | | MUL | | |
| U_Password | varchar(32) | | | | |
| U_Email | varchar(50) | YES | | NULL | |
| U_Fakeemail | varchar(50) | YES | | NULL | |
| U_Name | varchar(100) | YES | | NULL | |
| U_Totalposts | int(9) unsigned | YES | | NULL | |
| U_Laston | int(11) unsigned | YES | | NULL | |
| U_Signature | text | YES | | NULL | |
| U_Homepage | varchar(150) | YES | | NULL | |
| U_Occupation | varchar(150) | YES | | NULL | |
| U_Hobbies | varchar(200) | YES | | NULL | |
| U_Location | varchar(200) | YES | | NULL | |
| U_Bio | text | YES | | NULL | |
| U_Status | varchar(15) | | MUL | User | |
| U_Sort | int(4) unsigned | YES | | NULL | |
| U_Display | varchar(10) | | | | |
| U_View | varchar(10) | | | | |
| U_PostsPer | int(11) unsigned | YES | | NULL | |
| U_Number | int(9) unsigned | | PRI | NULL | auto_increment |
| U_EReplies | char(3) | | | | |
| U_Notify | char(3) | | | | |
| U_TextCols | char(3) | YES | | NULL | |
| U_TextRows | char(3) | YES | | NULL | |
| U_Extra1 | varchar(200) | YES | | NULL | |
| U_Extra2 | varchar(200) | YES | | NULL | |
| U_Extra3 | varchar(200) | YES | | NULL | |
| U_Extra4 | varchar(200) | YES | | NULL | |
| U_Extra5 | varchar(200) | YES | | NULL | |
| U_Post_Format | varchar(5) | | | | |
| U_Registered | int(11) unsigned | YES | | NULL | |
| U_Preview | varchar(5) | YES | | NULL | |
| U_Picture | varchar(150) | YES | | NULL | |
| U_PictureView | char(3) | YES | | NULL | |
| U_Visible | char(3) | YES | | yes | |
| U_PicturePosts | char(3) | YES | | NULL | |
| U_AcceptPriv | char(3) | YES | | yes | |
| U_RegEmail | varchar(50) | YES | | NULL | |
| U_RegIP | varchar(15) | YES | | NULL | |
| U_Groups | varchar(250) | YES | | -1- | |
| U_Language | varchar(20) | YES | | NULL | |
| U_Title | varchar(100) | YES | | NULL | |
| U_FlatPosts | char(2) | YES | | NULL | |
| U_TempPass | varchar(32) | YES | | NULL | |
| U_Color | varchar(15) | YES | | NULL | |
| U_TempRead | text | YES | | NULL | |
| U_StyleSheet | varchar(50) | YES | | NULL | |
| U_TimeOffset | varchar(10) | YES | | NULL | |
| U_Privates | int(4) unsigned | YES | | 0 | |
| U_FrontPage | varchar(20) | YES | | NULL | |
| U_ActiveThread | int(4) unsigned | YES | | NULL | |
| U_StartPage | char(2) | YES | | cp | |
| U_Favorites | varchar(250) | YES | | - | |
| U_ShowSigs | char(3) | YES | | NULL | |
| U_OnlineFormat | char(3) | YES | | NULL | |
| U_Rating | varchar(5) | YES | | 0 | |
| U_Rates | int(4) unsigned | YES | | 0 | |
| U_RealRating | int(1) unsigned | YES | | NULL | |
| U_PicWidth | int(4) unsigned | YES | | NULL | |
| U_PicHeight | int(4) unsigned | YES | | NULL | |
| U_SessionId | varchar(64) | | MUL | 0 | |
| U_Approved | char(3) | | MUL | | |
| U_Palprofile | int(11) unsigned | YES | | NULL | |
| U_AdminEmails | char(3) | YES | | On | |
| U_EmailFormat | varchar(10) | YES | | plaintext | |
+----------------+------------------+------+-----+-----------+----------------+
</PRE></pre>

There are other things that keep track of the users, what they've done, where they've been, etc...

This is what makes it more difficult than just using the Username & Password.

If you have any specific ideas, I'm open to listen...I'm still trying to make this work when I get spare time.

Cheers, Bill


------------------------------------------------------------
"Knowledge is of two kinds. We know a subject ourselves,
or we know where we can find information upon it."

-Samuel Johnson