乍么没有人关注呢?
我再贴上表结构:CREATE TABLE `prizing` (
`id` int(11) NOT NULL auto_increment,
`strmobile` varchar(12) NOT NULL default '',
`ordertime` date NOT NULL default '0000-00-00',
`yan` int(3) default '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1请大家帮帮忙啊!
我再贴上表结构:CREATE TABLE `prizing` (
`id` int(11) NOT NULL auto_increment,
`strmobile` varchar(12) NOT NULL default '',
`ordertime` date NOT NULL default '0000-00-00',
`yan` int(3) default '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1请大家帮帮忙啊!
你运行:
----------------------------------------------------------
select concat(month(curdate()), day(curdate())) as currdate,
concat(month(ordertime),day(ordertime)) as orderdate
from prizing
limit 50看有什么结果?
success!yun....thank you!