select c.attr_value from ecs_goods_attr c
inner join ecs_goods a
on c.goods_id=a.goods_id
where a.goods_name='s020039' and c.attr_value <>'apson'上面的select语句查出来的c.attr_value是一个用换行分开的n个字符串,我想把他们用换行分开,然后得到这n个值,
请问用select怎么写?
inner join ecs_goods a
on c.goods_id=a.goods_id
where a.goods_name='s020039' and c.attr_value <>'apson'上面的select语句查出来的c.attr_value是一个用换行分开的n个字符串,我想把他们用换行分开,然后得到这n个值,
请问用select怎么写?
Stylus 800和Stylus 1000中间是以回车的行式存在数据库中的... 结果是1个
想得到的结果:Stylus 800和Stylus 1000,用回车分开,结果是2个
应该是varchar类型 的吧
而我想的是要Stylus 800\r\nStylus 1000 中间的回车把它们分开,得到
Stylus 800,Stylus 1000两个结果,我描述明白了吗
Stylus 800\r\nStylus 1000 一条记录
你想要得到:
Stylus 800
Stylus 1000两条记录是这样?
sql语句中我取出它们要用回车再把它们分开,就这样..上面\r\n不是字符串,而是回车的标识..
没明白的话我再解释
类似于:
select concat('123',char(13),char(10),'456')
特别感谢wwwwa的帮助....
where a.goods_name='$_REQUEST[goods]' and c.attr_value <>'$_REQUEST[goodscat]'";
$page = !empty($_REQUEST['page']) && intval($_REQUEST['page']) > 0 ? intval($_REQUEST['page']) : 1;
$size = !empty($_CFG['page_size']) && intval($_CFG['page_size']) > 0 ? intval($_CFG['page_size']) : 10;
$display = 'grid';
$query = $db->query($sql);
$result = $db->fetchRow($query);
$goodsname = array();$gdname = array();
foreach($result as $value){
$goodsname = explode("\r\n",$value); }//在这儿得到$gdname
$gdname = array();
foreach($goodsname as $me){
$num = preg_match("/^(\s+|)$/",$me);
if($num==0){
$gdname[] = $me;
}
} print_r($gdname);
$count = count($gdname);
$sql = "SELECT g.goods_id, g.goods_name, g.et_price, g.is_new, g.is_best, g.is_hot, g.shop_price AS org_price, ".
"g.promote_price, g.promote_start_date, g.promote_end_date, g.goods_thumb, g.goods_img, g.goods_brief, g.goods_type ".
"FROM " .$ecs->table('goods'). " AS g where g.goods_name in ("; $num=0;
//在这运用它,就不用写那么复杂的sql了.
foreach ($gdname as $value){
$num++;
if($num==$count){
$sql .= "'".$value."'";
}
else{
$sql .= "'".$value."',";
}
}
$sql .= ")";然后再进行查询之类的...