OK - I got it to work perfectly - I only have one issue...
in my Users Table I have the following:
`UID` int(10) NOT NULL auto_increment,
`CID` int(10) default NULL,
`FID` int(10) default NULL,
`UDID` int(10) default NULL,
`CTID` int(10) default NULL,
`UEmail` varchar(255) default NULL,
`UPass` varchar(255) default NULL,
in my UserDetails table I have the following:
`UDID` int(10) NOT NULL auto_increment,
`FID` int(10) NOT NULL,
`UFName` varchar(255) NOT NULL,
`ULName` varchar(255) NOT NULL,
`USSN` varchar(11) NOT NULL,
`UCity` varchar(255) NOT NULL,
`UState` varchar(255) NOT NULL,
`UZipcode` int(5) NOT NULL,
`UPhone1` varchar(255) NOT NULL,
`UPhone2` varchar(255) default NULL,
`UReferred` varchar(255) NOT NULL,
`ULevel` int(2) NOT NULL default '1',
How do I get the UDID to populate the incremental one in the UserDetails table as well as the row in the Users table?
I have tried the pulling the UDID out of session, the post value from the registration form and any other way I can think of...
Everything I've tried the table has remained empty...
Any ideas?