Database problem

Anon

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 column(IP addres) 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

zhabala

Show us the SQL commands which do you use for updating.

Zdenek

Anon

Hello,

Here is my code.

Thanks once again.

<?php

  include "dbconnection.oam";

  if ($frm_save == 1)

{
$sql = "update TBL_XXX SET TFTPSERVER = '$tftp_server', IPADDRESS = '$ip_address', ROUTERIP = '$router_ip'";
$result = ibase_query($connection, $sql);
}
$db = 'Select TFTPSERVER,IPADDRESS,ROUTERIP from TBL_XXX';
$bsc = ibase_query($connection, $db);

Here all my field headings............

<?php

while ($row = ibase_fetch_object($bsc))
{
$tftpserver=$row->TFTPSERVER;
$ipaddress=$row->IPADDRESS;
$routerip=$row->ROUTERIP;

<td width="156" height="23" align="left" valign="top">
<p style="line-height:100%; margin-top:0; margin-bottom:0;"><FONT face=Verdana><SPAN style="FONT-SIZE: 10pt"><INPUT name=tftp_server value = "<? echo $tftpserver; ?>"style="padding:0;"></SPAN></FONT></p>

and here follows other fileds

<?php

}

?>
</table>

mrskhris

chand,

Your sql command update all records. Do you have unique ID in your table - something that you can give to update query to identify the row you want to update?

zhabala

You have to add a WHERE clause of UPDATE statement to say which record (records) will be updated:

$sql = "update TBL_XXX SET TFTPSERVER = '$tftp_server', IPADDRESS = '$ip_address', ROUTERIP = '$router_ip' WHERE id = $id";

where $id is value of column Id from your table.

Zdenek