Hello, I have code like following in asp. Then it can list the item I need in one row. Then I found maybe it is better to list them like 3 items per row. Then how to modify the code? Looking forward to receive your comment and hints!! Thanks in advance!
<%dim rs,conn Set conn=Server.createObject("ADODB.Connection") conn.open "xxx" set rs=Server.CreateObject("ADODB.Recordset") sql="select distinct (p_id+bg_id) as product from Tshirt_product where order_id='"&id&"'" rs.Open sql, conn do until rs.EOF response.write(rs("product")) Response.write("; ") rs.MoveNext loop rs.close conn.close %>