i have these 2 tables:
CREATE TABLE `_Users Info` (
`User ID` int(11) NOT NULL auto_increment,
`Username` varchar(50) NOT NULL default '',
`Password` varchar(50) NOT NULL default '',
`Email` varchar(50) default NULL,
`First Name` varchar(100) default NULL,
`Last Name` varchar(100) default NULL,
`CreatedByPHPRunner` int(11) default NULL,
PRIMARY KEY (`User ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
CREATE TABLE `_Users Transactions` (
`Transaction ID` int(11) NOT NULL auto_increment,
`User ID` int(11) NOT NULL default '0',
`Transaction Date` datetime NOT NULL default '0000-00-00 00:00:00',
`Access Until` datetime NOT NULL default '0000-00-00 00:00:00',
`Product` int(11) NOT NULL default '0',
`Amount` decimal(4,2) NOT NULL default '0.00',
`CreatedByPHPRunner` int(11) default NULL,
PRIMARY KEY (`Transaction ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
at the second table at the field user ID i need to select the user ID from the other table with a select form, i have been checking demos but there's something i do wrong,
could someone explain me exactly what to do?
thanks a lot
