我有一个Product master,其中我有两个字段,一个是主产品(字段名'Under'),第二个是子产品(字段名是‘Prod_desc’)我想要的是一个嵌套循环,我从事务表(ECR_CBDC)中捕获所有代码(字段名是Cylno)。$p=mysql_query("SELECT * FROM PRODMAST WHERE Under='$product'");
医生:
1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQLserver version for the right syntax to use near 'order DESC' at line 3 SQL=SELECT `id`,`image`,`order`,`status` FROM `vsem6_session_1` ORDER BY order DESC
我的
我有一个奇怪的问题与Mysql更新,我不确定是什么原因造成的。我怀疑表本身有问题,但导致错误的字段的定义似乎与表中的其他字段相同。length=60 Collation=latin1_swedish_cidesctwittername='myTweet' where bnumber=1;update tbl1 set bname='myName', twitternam
$query = mysql_query('SELECT * from rbf_edades_news order by month DESC '.$query = mysql_query('SELECT * from rbf_edades_news order by month and DESC '.$limit.'');
谢谢!
Project.where(:id => ids).order("FIELD(id,#{ids.join(',')})")
Mysql2::Error: You have an error in yourSQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to usenear 'DESC,1018 DESC,1017)