Question

求助关于购物网站中统计书本被购买次数的SQL语句该怎么写

就比如要购买2本书，然后在下订单的时候把购买的次数写进数据库中

Answer 1

id=cstr(request("id"))
Set rsnews1=Server.CreateObject("ADODB.RecordSet")
sql1="select * from news1 where id="&cstr(request("id"))
rsnews1.open sql1,conn,1,3
hits_sc=rsnews1("hits")
if hits_sc=null then hits_sc=0
rsnews1("hits")=hits_sc+1
rsnews1.update
rsnews1.close:set rsnews1=nothing

Answer 2

select count(*) from table_book