Bonjour,
CREATE TABLE IF NOT EXISTS `cashr_users` (
`id` int(5) NOT NULL AUTO_INCREMENT,
`username` varchar(15) NOT NULL DEFAULT '',
`password` varchar(15) NOT NULL DEFAULT '',
`firstname` varchar(30) NOT NULL DEFAULT '',
`lastname` varchar(30) NOT NULL DEFAULT '',
`email` varchar(60) NOT NULL DEFAULT '',
`sponsor` varchar(15) NOT NULL DEFAULT 'admin',
`egopay` varchar(255) NOT NULL,
`okpay` varchar(255) NOT NULL,
`paypal` varchar(60) NOT NULL DEFAULT 'none',
`payza` varchar(100) NOT NULL DEFAULT 'none',
`egold` varchar(50) NOT NULL DEFAULT 'none',
`solidtrustpay` varchar(75) NOT NULL DEFAULT 'none',
`perfectmoney` varchar(100) NOT NULL DEFAULT 'none',
`pmaccname` varchar(100) NOT NULL,
`skrill` varchar(100) NOT NULL DEFAULT 'none',
`weight` int(6) NOT NULL DEFAULT '1',
`lastlogin` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`joindate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`last_ip` varchar(15) NOT NULL DEFAULT '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='This table contains the users' AUTO_INCREMENT=38 ;
Ma requête actuelle affiche le nom et prénom des username qui ont des sponsors
$res=db_query("select firstname, lastname from cashr_users where sponsor IN(select username from cashr_users)");
Maintenant je veux afficher uniquement les username qui sont sponsor