table id field1 field2 field3 field4 1 aaaa bbbb ccccc dddd select id,field,orderno from (select id,field1 field,1 orderno from table union select id,field2 field,2 orderno from table union select id,field3 field,3 orderno from table union select id,field4 field,4 orderno from table) order by orderno看不懂就拿你没办法了
id field1 field2 field3 field4
1 aaaa bbbb ccccc dddd
select id,field,orderno from
(select id,field1 field,1 orderno from table
union
select id,field2 field,2 orderno from table
union
select id,field3 field,3 orderno from table
union
select id,field4 field,4 orderno from table)
order by orderno看不懂就拿你没办法了
如有一个层<div id="div1"/>
则 div1.innerHTML="aaaaa<br>bbbbb<br>cccccc<br>ddddd"
把aaaaaaaa
bbbbbbbbbbbbb
cccccccccc
转为aaaaaaaa <br>bbbbbbbbbbbbb<br> cccccccccc存进数据库!