从数组mysql列表中更新特定记录 [英] update a specific record from the list of array mysql

问题描述

我有一个表 user_instance 。它具有三个字段： account_id ， instance_name ， host_name 。

例如，记录是这样的。

I have a table user_instance. It has three fields: account_id, instance_name, host_name.
For Example, the records are like this.

account_id     instance_name      host_name
------------------------------------------
    1          instance_name1     localhost
    1          instance_name1     % 
    1          instance_name2     localhost
    2          instance_name1     localhost

在文本框数组中获取instance_name和host_name。

And I am getting instance_name and host_name in an array of text boxes.

$result=mysql_query("SELECT user_instance.instance_name, user_instance.host_name FROM
dba_account, user_instance WHERE dba_account.account_id = user_instance.account_id AND 
dba_account.account_id = '1'");

while($note = mysql_fetch_array($result))
{
<inut type='text' name='instance_name' class='instance_name' disabled='disabled' 
value='$note[instance_name]' size='25' />
<input type='text' name='host_name' class='host_name' disabled='disabled' 
value='$note[host_name]' size='25' /> 
}

现在，当我单击更新按钮时，它应该更新特定的记录我进行了更改。例如，如果我更改instance_name instance_name1 或host_name localhost 的account_id 1 ，那么它应该更新该记录。感谢您的帮助。

now when I click on the update button, it should update the specific record that I have made changes to. For example, if I change instance_name instance_name1 or host_name localhost of account_id 1, then it should update that record. I appreciate any help.

推荐答案

您永远不会执行 UPDATE 命令。

you are never executing an UPDATE command.

这篇关于从数组mysql列表中更新特定记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！