Update 2 record same time

[christa]

hi

my db table  has 2 field:

 

ID - Place

1    France

2    Germany

 

My form has 2 text field (printed with while cycle).

 

mysql_query("UPDATE mytable SET Place = '" . $_POST['place'] . "' WHERE ID=". $_POST['ID']." ");

 

This query doesn't work, because updates only the last record.

 

Where is wrong?

 

many thanks 

 

[MrXHellboy]

You lost me, what doest work and what do you need ?

[christa]

My db table  has 2 fields:

ID - Place

1    France

2    Germany

 

My form has 2 text fields:

input name=State1

input name=State2

 

if I digit Italy in inputname=State1 only updates ID 1

if I digit Spain in inputname=State2 only updates ID 2

 

So, my db table will become:

 

ID - Place

1    Italy

2    Spain

[MrXHellboy]

Then you have to check whether the input fields are empty... The same with your query

 

Something like:

if ($_POST['State1'] != '')
// query

if ($_POST['State2'] != '')
// query

 

I hope this helps because i still dont get it what you want exactly......