好 的! 公司表:# 表的结构 `company`CREATE TABLE `company` ( `Id` int(18) NOT NULL auto_increment, `LogID` varchar(40) NOT NULL default '', `PassWord` varchar(40) NOT NULL default '', `What` varchar(40) NOT NULL default '', `Answer` varchar(40) NOT NULL default '', `Name` varchar(40) NOT NULL default '', `Sex` enum('F','M') NOT NULL default 'M', `Email` varchar(75) NOT NULL default '', `Phone` varchar(25) NOT NULL default '', `Fax` varchar(25) default NULL, `Combined_Set` varchar(25) default NULL, `Postcode` varchar(10) default NULL, `province` varchar(30) NOT NULL default '', `city` varchar(20) NOT NULL default '', `M_address` varchar(80) NOT NULL default '', `Company_Name` varchar(100) NOT NULL default '', `MyJod` varchar(40) NOT NULL default '', `Trade` varchar(40) NOT NULL default '', `Type` varchar(20) NOT NULL default '', `Product` varchar(100) NOT NULL default '', `Introduction` text, `L_Time` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`Id`), UNIQUE KEY `LogID` (`LogID`) ) TYPE=MyISAM AUTO_INCREMENT=11 ;办事处表: CREATE TABLE `our_member_v` ( `id` int(15) NOT NULL auto_increment, `LogID` varchar(30) NOT NULL default '', `our_member_id` int(18) NOT NULL default '0', `checked` enum('N','Y') NOT NULL default 'N', `type` enum('0','1') NOT NULL default '0', `shenfen` varchar(100) NOT NULL default '', `province_daili` varchar(100) NOT NULL default '', `city_daili` varchar(100) NOT NULL default '', `Address` varchar(250) NOT NULL default '', `economy` varchar(50) NOT NULL default '', `dimension` varchar(100) NOT NULL default '', `population` varchar(50) NOT NULL default '', `identification` varchar(100) NOT NULL default '', `yinhangName` varchar(100) NOT NULL default '', `yinhangNO` varchar(100) NOT NULL default '', `Company_Name` varchar(150) NOT NULL default '', `MyJod` varchar(150) NOT NULL default '', `Trade` varchar(250) NOT NULL default '', `TradeType` varchar(100) NOT NULL default '', `Product` varchar(200) NOT NULL default '', `Introduction` text NOT NULL, `time` datetime NOT NULL default '0000-00-00 00:00:00', UNIQUE KEY `id` (`id`) ) TYPE=MyISAM AUTO_INCREMENT=7 ;样品表:CREATE TABLE `station_provision` ( `id` int(11) NOT NULL auto_increment, `p_account` varchar(100) NOT NULL default '', `p_account_type` varchar(100) NOT NULL default '', `p_title` varchar(250) NOT NULL default '', `p_specification` varchar(200) NOT NULL default '', `p_price` varchar(100) NOT NULL default '', `p_quanlity` varchar(100) NOT NULL default '', `p_type` varchar(100) NOT NULL default '', `p_usetime` varchar(100) NOT NULL default '', `p_pic` varchar(250) NOT NULL default '', `p_introduce` text NOT NULL, `p_time` datetime NOT NULL default '0000-00-00 00:00:00', KEY `id` (`id`) ) TYPE=MyISAM AUTO_INCREMENT=7 ;问题:??????????????? 要查询出所有代理地点是同一个地方的样品:比如(“广东”,“汕头”);sql_select = "select t1.* from station_provision as t1,company as t2 where t2.province". " ='广东'and t2.city ='汕头' and t1.p_account =t2.LogID union". " select t1.* from station_provision as t1,our_member_v as t3 where t3.province_daili". " ='广东' and t3.city_daili ='汕头' and t1.p_account =t3.LogID order by t1.p_time desc limit $start,$onepage"; 是可以实现,但我空间的数据库版本太低不支持,要怎么该才有用?请作答!
mysql 版本问题,版本太低,不支持联合查询. 建议,装更高的版本或者 分次查询,把查询出来的东西加入数组. 然后再循环输出
是啊,MYSQL不支持子查询,是一大遗憾
拆成这三句 carete temporary tamle tmp select t1.* from station_provision as t1,company as t2 where t2.province='$province_daili' and t2.city ='$city_daili' and t1.p_account =t2.LogID insert ioto tmp select t1.* from station_provision as t1,our_member_v as t3 where t3.province_daili='$province_daili' and t3.city_daili ='$city_daili' and t1.p_account =t3.LogID select * form tmp order by p_time desc limit $start,$onepage
有什么办法可以解决,请你改一下给我看好吗
`Id` int(18) NOT NULL auto_increment,
`LogID` varchar(40) NOT NULL default '',
`PassWord` varchar(40) NOT NULL default '',
`What` varchar(40) NOT NULL default '',
`Answer` varchar(40) NOT NULL default '',
`Name` varchar(40) NOT NULL default '',
`Sex` enum('F','M') NOT NULL default 'M',
`Email` varchar(75) NOT NULL default '',
`Phone` varchar(25) NOT NULL default '',
`Fax` varchar(25) default NULL,
`Combined_Set` varchar(25) default NULL,
`Postcode` varchar(10) default NULL,
`province` varchar(30) NOT NULL default '',
`city` varchar(20) NOT NULL default '',
`M_address` varchar(80) NOT NULL default '',
`Company_Name` varchar(100) NOT NULL default '',
`MyJod` varchar(40) NOT NULL default '',
`Trade` varchar(40) NOT NULL default '',
`Type` varchar(20) NOT NULL default '',
`Product` varchar(100) NOT NULL default '',
`Introduction` text,
`L_Time` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`Id`),
UNIQUE KEY `LogID` (`LogID`)
) TYPE=MyISAM AUTO_INCREMENT=11 ;办事处表:
CREATE TABLE `our_member_v` (
`id` int(15) NOT NULL auto_increment,
`LogID` varchar(30) NOT NULL default '',
`our_member_id` int(18) NOT NULL default '0',
`checked` enum('N','Y') NOT NULL default 'N',
`type` enum('0','1') NOT NULL default '0',
`shenfen` varchar(100) NOT NULL default '',
`province_daili` varchar(100) NOT NULL default '',
`city_daili` varchar(100) NOT NULL default '',
`Address` varchar(250) NOT NULL default '',
`economy` varchar(50) NOT NULL default '',
`dimension` varchar(100) NOT NULL default '',
`population` varchar(50) NOT NULL default '',
`identification` varchar(100) NOT NULL default '',
`yinhangName` varchar(100) NOT NULL default '',
`yinhangNO` varchar(100) NOT NULL default '',
`Company_Name` varchar(150) NOT NULL default '',
`MyJod` varchar(150) NOT NULL default '',
`Trade` varchar(250) NOT NULL default '',
`TradeType` varchar(100) NOT NULL default '',
`Product` varchar(200) NOT NULL default '',
`Introduction` text NOT NULL,
`time` datetime NOT NULL default '0000-00-00 00:00:00',
UNIQUE KEY `id` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=7 ;样品表:CREATE TABLE `station_provision` (
`id` int(11) NOT NULL auto_increment,
`p_account` varchar(100) NOT NULL default '',
`p_account_type` varchar(100) NOT NULL default '',
`p_title` varchar(250) NOT NULL default '',
`p_specification` varchar(200) NOT NULL default '',
`p_price` varchar(100) NOT NULL default '',
`p_quanlity` varchar(100) NOT NULL default '',
`p_type` varchar(100) NOT NULL default '',
`p_usetime` varchar(100) NOT NULL default '',
`p_pic` varchar(250) NOT NULL default '',
`p_introduce` text NOT NULL,
`p_time` datetime NOT NULL default '0000-00-00 00:00:00',
KEY `id` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=7 ;问题:???????????????
要查询出所有代理地点是同一个地方的样品:比如(“广东”,“汕头”);sql_select = "select t1.* from station_provision as t1,company as t2 where t2.province".
" ='广东'and t2.city ='汕头' and t1.p_account =t2.LogID union".
" select t1.* from station_provision as t1,our_member_v as t3 where t3.province_daili".
" ='广东' and t3.city_daili ='汕头' and t1.p_account =t3.LogID order by t1.p_time desc limit $start,$onepage";
是可以实现,但我空间的数据库版本太低不支持,要怎么该才有用?请作答!
carete temporary tamle tmp select t1.* from station_provision as t1,company as t2 where t2.province='$province_daili' and t2.city ='$city_daili' and t1.p_account =t2.LogID
insert ioto tmp select t1.* from station_provision as t1,our_member_v as t3 where t3.province_daili='$province_daili' and t3.city_daili ='$city_daili' and t1.p_account =t3.LogID
select * form tmp order by p_time desc limit $start,$onepage
可以告诉我tmp是什么吗,是缓存吗?