一个很普通查询输出函数现在表中有10条数据
调用的时候因为要把结果转成XML所以不能在函数体里做echo
但是这样调用只能输出最后一条记录,求能在调用页面输出整表内容的方法调用
echo main_shopactive();函数体
function main_shopactive()
{
//商场活动查询,返回逆向排序的最后一条活动记录
$conn = mysql_connect_conn();
$sql = "SELECT * FROM wx_active order by id desc limit 0,30";
$rs = mysql_db($sql,$conn) or die('查询记录失败!');
if(mysql_num_rows($rs) > 0)
{
while($row = mysql_fetch_assoc($rs))
{
$my_active = $row['concent'];
}
}
else
{
$my_active = 'NO ACTIVE';
}
return $my_active;
}
{
$my_active[] = $row['concent'];
}
$my_active .= $row['concent'];
return $my_active;也可以
$my_active[] = $row['concent'];
return join('', $my_active);
结果应该是这样的:'dior一楼化妆品0412-8999960资生堂一楼化妆品0412-89999961'
现在却是这样:'dior资生堂一楼一楼0412-89999600412-89999961化妆品化妆品'
什么原因啊?字段排列顺序完全不对呢。调用页面$floor_find = new floor_product_lookfor();
echo ($floor_find->floor_product('一楼'));原来类和函数
class floor_product_lookfor
{
function floor_product($floor_nunmer)
{
$conn = mysql_connect_conn();
$sql = "SELECT * FROM wx_floor where goods_floor ='$floor_nunmer' order by goods_id desc";
$rs = mysql_db($sql,$conn) or die('查询记录失败!');
if(mysql_num_rows($rs) > 0)
{
while($row = mysql_fetch_assoc($rs))
{
$floor .= $row['goods_name'];
$name .= $row['goods_floor'];
$tel .= $row['goods_tel'];
$type .= $row['goods_type'];
}
}
else
{
$floor = 'NO GOODS INFORMATION';
}
return ($floor.$name.$tel.$type);
}
}
既然你简化了你的代码(没有给出记录间的分隔符)那当然是混在一起的
至少你需要给出你期望的数据格式其实产生 xml 节点数据是可以在 sql 指令中直接完成的
这样的效果就是我所期望的,麻烦版主大人了
dior一楼化妆品0412-8999960
资生堂一楼化妆品0412-89999961
{
$value .= $row['goods_name'] . $row['goods_floor'] . $row['goods_tel'] . $type .= $row['goods_type'];
}
return $value;