百万美元脚本中的SQL查询错误 [英] Sql query error in million dollar script

问题描述

我有百万美元的网站脚本，这使我能够出售像素块，但每当我尝试添加新广告时，它会给我以下错误。

你有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屋！