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