请教各位大哥一个表设计问题
以下是一个网页,把它存入一个html文件即可,注意,每一款衣服都是从数据库里取的,是活的,针对每一款衣服有一些码,可以输入数字
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN " "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd ">
<html xmlns= "http://www.w3.org/1999/xhtml ">
<head>
<meta http-equiv= "Content-Type " content= "text/html; charset=gb2312 " />
<title> Untitled Document </title>
</head>
<body>
<P align=left> <INPUT type=checkbox value=ON name=C1> 衣服款式1 </P>
<P align=left> <FONT face=Verdana size=1>
XS Qty
<INPUT size=3 name=T1>
Small Qty
<INPUT size=3 name=T1>
Med Qty
<INPUT size=3 name=T1>
Large Qty
<INPUT size=3 name=T1>
XL Qty
<INPUT size=3 name=T1>
2XL Qty
<INPUT size=3 name=T1>
3XL Qty
<INPUT size=3 name=T1>
</FONT> </P>
<P align=left> <FONT face=Verdana size=1>
Total Quantity <INPUT size=5 name=T1>
Total Amount <INPUT size=5 name=T1> </FONT> </P>
<P align=left> <INPUT type=checkbox value=ON name=C1> 衣服款式2 </P>
<P align=left> <FONT face=Verdana size=1>
XS Qty
<INPUT size=3 name=T1>
Small Qty
<INPUT size=3 name=T1>
Med Qty
<INPUT size=3 name=T1>
Large Qty
<INPUT size=3 name=T1>
XL Qty
<INPUT size=3 name=T1>
2XL Qty
<INPUT size=3 name=T1>
3XL Qty
<INPUT size=3 name=T1>
</FONT> </P>
<P align=left> <FONT face=Verdana size=1>
Total Quantity <INPUT size=5 name=T1>
Total Amount <INPUT size=5 name=T1> </FONT> </P>
<P align=left> <INPUT type=checkbox value=ON name=C1> 衣服款式3 </P>
<P align=left> <FONT face=Verdana size=1>
XS Qty
<INPUT size=3 name=T1>
Small Qty
<INPUT size=3 name=T1>
Med Qty
<INPUT size=3 name=T1>
Large Qty
<INPUT size=3 name=T1>
XL Qty
<INPUT size=3 name=T1>
2XL Qty
<INPUT size=3 name=T1>
3XL Qty
<INPUT size=3 name=T1>
</FONT> </P>
<P align=left> <FONT face=Verdana size=1>
Total Quantity <INPUT size=5 name=T1>
Total Amount <INPUT size=5 name=T1> </FONT> </P>
</body>
</html>
[解决办法]
create table 款式表
(
款式编码 char(4),
款式名称 varchar(20),
XSQty int,
SmallQty int ,
--以下依次把下面的列写上
--MedQty LargeQty XLQty 2XLQty 3XLQty TotalQuantity
TotalAmount int
)
