asp update语句

if bid <>"" and isnumeric(bid) then
stsql="select * from pic where leixing ="&bid&" order by id"
else
if jdkeyword<>"" then
stsql="select * from pic where name like '%"&jdkeyword&"%' order by id"
else
stsql="select * from pic order by id"

修改为：

if bid <>"" and isnumeric(bid) then
stsql="select * from pic where leixing ="&bid&" order by id desc"
else
if jdkeyword<>"" then
stsql="select * from pic where name like '%"&jdkeyword&"%' order by id desc"
else
stsql="select * from pic order by id desc"