Update Multiple Records

[Anon]

Having difficulty getting my code to work. And I can't find the problem for the life of me.

I want to update multiple records... Here's what I've got:

if (isset($Submit)):
$sql="update eom_vote set eom_vote.Value=Value where eom_vote.ID=ID";
$result=mysql_query($sql);
endif;

$sql="select eom_vote.ID, eom_vote.Name, eom_vote.Value from eom_vote order by eom_vote.ID";

$result=mysql_query($sql);
echo("<form name=\"form\" method=\"post\" action=\"showeom.php\"><table><tr>");

echo("<b>EOM Nominees</b><br>");
echo("<br>");
if (mysql_num_rows($result)>0):
while ($row=mysql_fetch_array($result))
{
print ("<input type=text Name=Value[$row[0]] Value=$row[2]><br><br>\n");
}
endif;

mysql_free_result($result);
?>
</table>
<p align=center><input type=Submit Name=Submit Value="Click to Update"></p>

</form>

[Anon]

In the update query:

eom_vote.Value=Value

you're setting the field to itself! So it's not modifying it...Generally a PHP variable is put there, something like:

eom_vote.Value = $value

Diego

[Anon]

Okay... Changed it to:

$sql="update eom_vote set eom_vote.Value = $value where eom_vote.ID = $ID";

I've also tried

$sql="update eom_vote set eom_vote.Value = $value where eom_vote.ID = ID";

Am I missing it? Obviously I am. I know it has to do with the list of results (since I'm calling all records here:

if (mysql_num_rows($result)>0):

while ($row=mysql_fetch_array($result))

{
print ("<input type=text Name=Value[$row[0]] Value=$row[2]><br><br>\n");

I'm just loosing it somewhere along the way.

[Anon]

you never told me what the problem was...Does the database get updated? Does it get updated but results can't be displayed? or what?

Diego

[Anon]

The database does not update.

[Anon]

ok, what's the variable that has the new value for the eom_set.Value field? Is it $value?

Diego

[Anon]

Yes

[Anon]

How do you know it's not getting updated? Have you actually checked the database? Or do you just see if your code that's below that displays any results?

Diego

[Anon]

I've checked the database. It's driving me nuts!!!!