how to integrate a stand-alone script with vb?

[TalkVirginia]

I have a stand-alone php script that I'm attempting to integrate with vb. The script has it's own users table, however I'd like to integrate it in such a way that it will use the vb users table in addition to the extra fields that are unique to the scripts user table. What would I need to do? Alter the script's user table to match the user id field of vb's user table?

Here is the sql I'm using to create the script's user table:



CREATE TABLE nflp_users (
userID int AUTO_INCREMENT NOT NULL,
userName varchar(32) NOT NULL,
password varchar(255) NOT NULL,
salt varchar(255) NOT NULL,
firstname varchar(255),
lastname varchar(255),
email varchar(255) NOT NULL,
`status` tinyint(1) DEFAULT '1',
/* Keys */
PRIMARY KEY (userID)
) ENGINE = MyISAM
CHARACTER SET utf8 COLLATE utf8_general_ci;



Please advise,

Thanks in advance,
Jim

[Lynne]

All you really need to tie the two tables together is the userid. If you use the same userid in the user table is in your nflp_users table, then it's just a simple JOIN to match the two tables up.

[TalkVirginia]

Thank you very much :)