已解决问题
谷歌dggrmyzix用户在2014.05.11提交了关于“上甘岭php中插入一条**到mysql，用print打印这个sql语句，怎么sql语句的顺序会乱，而且，里面两个旨变了”的提问，欢迎大家涌跃发表自己的观点。目前共有1个回答，最后更新于2024-10-24T09:56:17。我的php代码:$shopName='家乐福1号店';
$userID='001';
$require='香烟1000条,啤酒1百箱';
echo$shopName;
$query=sprintf("selectSh**OPID,CODEIDfromt_codewhereSh**OPNAME='%s'",$shopName);
print($query);
$result=mysql_query($query,$conn)ordie(mysql_error());
$shopID=**ll;
$codeID=**ll;
while($row=mysql_fetch_array($result,MYSQL_ASSOC))
{
$shopID=$row['Sh**OPID'];
$codeID=$row['CODEID'];
}
echo'shopID='.$shopID.'<br/>';
echo'codeID='.$codeID.'<br/>';
$query1='selectTASKID,RECNOfromt_task';
$result2=mysql_query($query1);
$taskID=**ll;
$recNo=**ll;
while($row=mysql_fetch_array($result2,MYSQL_ASSOC))
{
$taskID=$row['TASKID'];
$recNo=$row['RECNO'];
$taskID++;
$recNo++;
}
echo'taskID='.$taskID.'<br/>';
echo'recNo='.$recNo.'<br/>';
if($taskID==**ll)
{
$taskID=1;
}
if($recNo==**ll)
{
$recNo=1;
}
$queryInsert=sprintf("insertintot_task".
"('TASKID','TASKDATE','Sh**OPID','CODEID','Sh**OPNAME','U**RID','RECNO','**MBERS','TYPE','STATUS','REQUIRE','EXPL','h**OMEDIR','INTIME','OUTTIME')VALUES".
"(%d,'%s','%s','%s','%s','%s',%d,%d,'s','s','%s','%s','%s','%s','%s')",
$taskID,date('Y-m-dh**:i:s',time()),$shopID,$codeID,$shopName,$userID,$recNo,0,'Y','Y',$require,**LL,'D:/WWW/JAYh**UANG/DATA',**LL,**LL);
print($queryInsert);
mysql_query($queryInsert,$conn)ordie(mysql_error());
我使用print打印出来的sql语句变成了insertintot_task('TASKID','TASKDATE','Sh**OPID','CODEID','Sh**OPNAME','U**RID','RECNO','**MBERS','TYPE','STATUS','REQUIRE','EXPL','h**OMEDIR','INTIME','OUTTIME')VALUES(7,'2013-04-0117:02:20','0000000001','00000001','家乐福1号店','001',7,0,'s','s','Y','Y','香烟1000条,啤酒1百箱','','D:/WWW/JAYh**UANG/DATA')，为什么'INTIME','OUTTIME'的值不见了，而'**MBERS'和'TYPE'之间多了两个's','s'，不知道怎么出来了，哪位帮我看下是什么错误导致的啊希望大家能够帮助她。
详细问题描述及疑问：我的php代码:
$shopName='家乐福1号店';
$userID='001';
$require='香烟1000条,啤酒1百箱';
echo$shopName;
$query=sprintf("selectSh**OPID,CODEIDfromt_codewhereSh**OPNAME='%s'",$shopName);
print($query);
$result=mysql_query($query,$conn)ordie(mysql_error());
$shopID=**ll;
$codeID=**ll;
while($row=mysql_fetch_array($result,MYSQL_ASSOC))
{
$shopID=$row['Sh**OPID'];
$codeID=$row['CODEID'];
}
echo'shopID='.$shopID.'<br/>';
echo'codeID='.$codeID.'<br/>';
$query1='selectTASKID,RECNOfromt_task';
$result2=mysql_query($query1);
$taskID=**ll;
$recNo=**ll;
while($row=mysql_fetch_array($result2,MYSQL_ASSOC))
{
$taskID=$row['TASKID'];
$recNo=$row['RECNO'];
$taskID++;
$recNo++;
}
echo'taskID='.$taskID.'<br/>';
echo'recNo='.$recNo.'<br/>';
if($taskID==**ll)
{
$taskID=1;
}
if($recNo==**ll)
{
$recNo=1;
}
$queryInsert=sprintf("insertintot_task".
"('TASKID','TASKDATE','Sh**OPID','CODEID','Sh**OPNAME','U**RID','RECNO','**MBERS','TYPE','STATUS','REQUIRE','EXPL','h**OMEDIR','INTIME','OUTTIME')VALUES".
"(%d,'%s','%s','%s','%s','%s',%d,%d,'s','s','%s','%s','%s','%s','%s')",
$taskID,date('Y-m-dh**:i:s',time()),$shopID,$codeID,$shopName,$userID,$recNo,0,'Y','Y',$require,**LL,'D:/WWW/JAYh**UANG/DATA',**LL,**LL);
print($queryInsert);
mysql_query($queryInsert,$conn)ordie(mysql_error());
我使用print打印出来的sql语句变成了insertintot_task('TASKID','TASKDATE','Sh**OPID','CODEID','Sh**OPNAME','U**RID','RECNO','**MBERS','TYPE','STATUS','REQUIRE','EXPL','h**OMEDIR','INTIME','OUTTIME')VALUES(7,'2013-04-0117:02:20','0000000001','00000001','家乐福1号店','001',7,0,'s','s','Y','Y','香烟1000条,啤酒1百箱','','D:/WWW/JAYh**UANG/DATA')，为什么'INTIME','OUTTIME'的值不见了，而'**MBERS'和'TYPE'之间多了两个's','s'，不知道怎么出来了，哪位帮我看下是什么错误导致的啊期待您的答案，不知道说什么,送你一朵小红花吧
！