search for: idx_name

Displaying 1 result from an estimated 1 matches for "idx_name".

2010 May 01
1
I need some help joining data from 3 MySQL tables, please
...', `registerDate` datetime NOT NULL default '0000-00-00 00:00:00', `lastvisitDate` datetime NOT NULL default '0000-00-00 00:00:00', `activation` varchar(100) NOT NULL default '', `params` text NOT NULL, PRIMARY KEY (`id`), KEY `usertype` (`usertype`), KEY `idx_name` (`name`), KEY `gid_block` (`gid`,`block`), KEY `username` (`username`), KEY `email` (`email`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=73 ; CREATE TABLE IF NOT EXISTS `jos_mls_teams_members` ( `id` int(11) NOT NULL auto_increment, `teamid` int(11) NOT NULL default '0...