19/12/2006, 08:35
|
| | | Fecha de Ingreso: diciembre-2006 Ubicación: Miami
Mensajes: 55
Antigüedad: 18 años, 3 meses Puntos: 0 | |
 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";
?>
Última edición por santuariosw; 19/12/2006 a las 15:15 |