Database and PHP forms

Hello,

In my form, i am trying to display all the fields from my table and also trying to update them.I've noticed something strange!!

1.Only the last entered value into the table can only be updated.

2.When i try to update a column for example, IP address, all rows are getting updated.

For example, if we have a table structure like this:

Id IP address Router Ip TFTP server
--------------------------------------------------------
Now, I tried to enter the following values through one of my form.

1 101.202.303 111.222.333 987.654.323

and again when i try to enter a new set of values, i see the previoulsy entered record again but with a different Id number.

So, it looks some thing like this now.

1 101.202.303 111.222.333 987.654.323
5 101.202.303 111.222.333 987.654.323

Now, when i try to update the second column8IP address) with id being 1, it does'nt get updated.With id 5, it gets updated but the first record also gets updated.

Why is this happening, aint sure why itz like that.

I'm using interbase as my database.

your help would be highly appreciated.

Thanks in advance

Perhaps if you posted the code, it would be a little easier to help you debug.

yeah, plz post ya code

yeah, plz post ya code

An easy way to see what happens is to echo out the sql command you send to your database.
Then you cut and paste this into your SQL command tool and execute it.
This will help you find any errors in the sql command.
Also you should secure that you dont have columns that are unique or autoincrement and so on.