Condicion de Update ?? estructura de la tabla
ID Date transfer1 to1 Date1 transfer2 to2 Date2
1 01/01/06 Dpto1 Rebeca 01/01/06 ??? ?? ???
<?
$search1 = @mysql_query ("SELECT date1 FROM members WHERE id=$id");
$search2 = @mysql_query ("SELECT date2 FROM members WHERE id=$id");
$search3 = @mysql_query ("SELECT date3 FROM members WHERE id=$id");
if ($search < 1);
$transfer1 = "UPDATE members SET department1=$sel1, people1=$sel2, date1=$date where id=$id";
elseif ($search2 < 1);
$transfer2 = "UPDATE members SET department2=$sel1, people2=$sel2, date2=$date where id=$id";
elseif ($search3 < 2);
$transfer3 = "UPDATE members SET department3=$sel1, people3=$sel2, date3=$date where id=$id";
?>
