what is the problem with my website?

Question

'800a0401'

语句未结束

/left.asp，行 14

sql1="select top 5 * from Product1 where bigclassname='公司新闻' order by articleid desc" Set rs1= Server.CreateObject("ADODB.Recordset") rs1.open sql1,conn,1,1
----------------------------------------------------------------------------------^

Answer 1

ask th yahoo group

Answer 2

First why you write the name of table by Japanese Lang ...when you Programing with php and mysql you must used English Lang
This the first thing ...
the sacand you must to but `` when you write name of table
and record cos mysql don't know if that is function of just name
of table cos that you must do like that
sql1="SELECT * FROM `pRODUCT1` WHERE bigclassname= '$varible'";
That is the correct .

Answer 3

the "select top 5" should be "select top_5" or "select top5" as defined in the sql database with no spacing.

mercury of love