表结构:
CREATE TABLE `items` (
`id` int(11) NOT NULL auto_increment,
`reviewid` int(11) default NULL,
`query` varchar(100) default NULL,
`query_cat` varchar(100) default NULL,
`title` varchar(100) default NULL,
`url` varchar(100) default NULL,
`pic_url` varchar(100) default NULL,
`sell_count` varchar(10) default NULL,
`credit` varchar(10) default NULL,
`good_rate` varchar(10) default NULL,
`getsum` int(11) default '0' COMMENT '多人评测中被获取次数',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=80001 DEFAULT CHARSET=gbkCREATE TABLE `score` (
`id` int(11) NOT NULL auto_increment,
`username` varchar(20) default NULL,
`itemid` int(11) default NULL,
`` varchar(10) default NULL,
`spam` varchar(10) default NULL,
`spam_des` varchar(20) default NULL,
`note` varchar(200) default NULL,
`status` int(11) default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=509 DEFAULT CHARSET=gbk查询语句select * from items left join score on items.id=score.itemid
where score.status=0 and score.username='神秘的桃子' items和score表都有id字段,怎么获取呢
$rs=$db->getRs("select * from items left join score on items.id=score.itemid
where score.status=0 and score.username='神秘的桃子' ");
用$rs["id"]获取的是score的id,怎么获取items的id呢
CREATE TABLE `items` (
`id` int(11) NOT NULL auto_increment,
`reviewid` int(11) default NULL,
`query` varchar(100) default NULL,
`query_cat` varchar(100) default NULL,
`title` varchar(100) default NULL,
`url` varchar(100) default NULL,
`pic_url` varchar(100) default NULL,
`sell_count` varchar(10) default NULL,
`credit` varchar(10) default NULL,
`good_rate` varchar(10) default NULL,
`getsum` int(11) default '0' COMMENT '多人评测中被获取次数',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=80001 DEFAULT CHARSET=gbkCREATE TABLE `score` (
`id` int(11) NOT NULL auto_increment,
`username` varchar(20) default NULL,
`itemid` int(11) default NULL,
`` varchar(10) default NULL,
`spam` varchar(10) default NULL,
`spam_des` varchar(20) default NULL,
`note` varchar(200) default NULL,
`status` int(11) default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=509 DEFAULT CHARSET=gbk查询语句select * from items left join score on items.id=score.itemid
where score.status=0 and score.username='神秘的桃子' items和score表都有id字段,怎么获取呢
$rs=$db->getRs("select * from items left join score on items.id=score.itemid
where score.status=0 and score.username='神秘的桃子' ");
用$rs["id"]获取的是score的id,怎么获取items的id呢
where score.status=0 and score.username='神秘的桃子'
where score.status=0 and score.username='神秘的桃子' 就对了
可我查询完需要获取score.id的值