A question about Query was empty

[dreamer365]

Please help me!

The program is about the PHP&MYSQL.Please check the code.

---

$sqlUpdate="update dict_list set dict_listname='".$list_name."',dict_listsmall='".$list_small."',dict_listremark='".$list_remark."',dict_listorder=".$list_order." where dict_listid=".$edit_id;
echo $sqlUpdate."<br>";

mysql_query($sqlupdate,$conn) or die(mysql_error());

But I run code appear a error "Query was empty"

I echo the SqlUpdate code:
update dict_list set dict_listname='administrator',dict_listsmall='admin,dict_listremark='The administrator accounts',dict_listorder=1 where dict_listid=3

But I can success run SqlUpdate on phpmyadmin,why?

[johanafm]

For some reason, your code doesn't match the output you provide here:
dict_listsmall='admin,

Should be (as it looks in the code you posted):
dict_listsmall='admin',

But your problem is here

$sqlUpdate = ...;

// ...

mysql_query($sqlupdate

[paulnaj]

You might be able to see what's going on if you lay out your code a bit better ...

$sqlUpdate="
UPDATE dict_list 
SET dict_listname = '".$list_name."'
, dict_listsmall = '".$list_small."'
, dict_listremark = '".$list_remark."'
, dict_listorder = ".$list_order." 
WHERE dict_listid = ".$edit_id;

Can you see the error now?

P 😉

[dreamer365]

Thank johanafm & paulnaj.

I puzzle about the problem.I try it again.