简单问题,在线送分.

[zyh791211]

有一语句:rs_s.open "select * from shop_anclass order by anclassidorder",conn,1,1
现查询显示出shop_anclass中的某一字段的所有内容nclass,但有一个anclassid=50的我不想让他显示.该如何写,谢谢~!

[zyh791211]

上面的某一字段就是nclass

[baiyunfei]

select * from shop_anclass where anclassid<>50 order by anclassidorder

[lstup]

被抢了，楼主可以给分了^_^