百万美元脚本中的SQL查询错误 [英] Sql query error in million dollar script
本文介绍了百万美元脚本中的SQL查询错误的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有百万美元的网站脚本,这使我能够出售像素块,但每当我尝试添加新广告时,它会给我以下错误。
你有SQL语法中的错误;请检查与MySQL服务器版本对应的手册,以便在AS ID,t2.field_comment AS FCOMMENT FROM form_fields AS t1,form_field_translati第1行附近使用正确的语法
这里是完整的查询
SELECT t2.field_label AS FLABEL,t1。* AS ID,t2.field_comment AS FCOMMENT FROM form_fields AS t1,form_field_translations AS t2 WHERE t1.field_id = t2.field_id AND lang ='。< span class =code-keyword> $ _ SESSION [' MDS_LANG']。< span class =code-string> 'AND section ='$ section'AND form_id ='$ form_id'$ where_sql order by field_sort
请帮忙。
我尝试过:
还没有尝试任何东西,但我仍然是php和mysql的新手因此我被困在这里这就是为什么我下载了一个现成的脚本。
解决方案
_SESSION [' MDS_LANG']。 'AND section ='
section'AND form_id ='
form_id'
I have million dollar website script which enables me to sell pixel blocks but whenever i try to add new advertisement it gives me the following error.
"You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AS ID, t2.field_comment AS FCOMMENT FROM form_fields AS t1, form_field_translati' at line 1"
here is the complete query
"SELECT t2.field_label AS FLABEL, t1.* AS ID, t2.field_comment AS FCOMMENT FROM form_fields AS t1, form_field_translations AS t2 WHERE t1.field_id=t2.field_id AND lang='".$_SESSION['MDS_LANG']."' AND section='$section' AND form_id='$form_id' $where_sql order by field_sort"
please help.
What I have tried:
haven't tried anything yet i am still new to php and mysql therefore i am stuck in here thats why i downloaded a ready made script.
解决方案
_SESSION['MDS_LANG']."' AND section='
section' AND form_id='
form_id'
这篇关于百万美元脚本中的SQL查询错误的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文