Question

I am using it to do with PHP.

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 at line 1

http://www.ohchr.org。

$SQLQUERY = sprintf("SELECT pd_serial FROM product_details WHERE pd_model_type=%s AND pd_model_name=%s AND pd_model_version=%s AND pd_product_group=%s LIMIT 1",
GetSQLValueString($modeltype, "text"),
GetSQLValueString($modelname, "text"),
GetSQLValueString($modelversion, "text"),
GetSQLValueString($modelgroup, "text"));
$QUERYEXEC =  mysql_query($SQLQUERY, $dacreint) or die("OOPS! Please try again.");

while ($QUERYFETCH = mysql_fetch_array($QUERYEXEC))
{
    $pdserial = $QUERYFETCH[ pd_serial ];
}

<><><><>>>>

while ($QUERYFETCH = mysql_fetch_array($QUERYEXEC))
{
    $pdserial = $QUERYFETCH[ pd_serial ];
}
$SQLQUERY = sprintf("SELECT product_serial_no FROM products WHERE product_serial_no =  $product_serial_no ");
$TCcount_QE = mysql_query($SQLQUERY, $dacreint) or die(mysql_error());

Answer 1

You should put strings within single quotes. And make sure you have escaped those string values using mysql_real_escape_string() or similar function

SELECT pd_serial FROM product_details WHERE (pd_model_type= %s  AND pd_model_name= %s ) AND (pd_model_version= %s  AND pd_model_group= %s ) LIMIT 1

<>12>

            while ($QUERYFETCH = mysql_fetch_array($QUERYEXEC))
            {
                $pdserial = $QUERYFETCH[ pd_serial ];
            }
    // let s comment out the following line
        //    $SQLQUERY = sprintf("SELECT product_serial_no FROM products WHERE product_serial_no =  $product_serial_no ");
// and modifying it as:
            $SQLQUERY = sprintf("SELECT product_serial_no FROM products WHERE product_serial_no = %s", GetSQLValueString($product_serial_no, "text"));
            $TCcount_QE = mysql_query($SQLQUERY, $dacreint) or die(mysql_error());

Answer 2

请补充“提出”问题吗? 你们的参数是否应当包含在引用的“%”中?

顺便说一句:你不必把母子放在一个完全与“任务”挂钩的WHERE-statement中。

Answer 3

这里是正确的。

SELECT pd_serial FROM product_details WHERE pd_model_type=%s AND pd_model_name=%s AND pd_model_version=%s AND pd_model_group=%s LIMIT 1

Edited

SELECT pd_serial FROM product_details WHERE pd_model_type like  %s  AND pd_model_name like  %s  AND pd_model_version like  %s  AND pd_model_group like  %s  LIMIT 1

由于我们在这里使用野生卡,因此Sorry i 想像在括号中那样附上条件,而我就失踪了。

友情链接