miren este codigo:
Código PHP:
<link href="estilos.css" rel="stylesheet" type="text/css">
<?
$host="localhost";
$user="ayuda_web";
$pass="xxxx";
$data="ayuda_web";
include("conexiones/conex1.php");
$link=Conectarse($host,$user,$pass,$data);
$query = mysql_query("SELECT * FROM usuarios_pro1 WHERE nick='".$_COOKIE['login']."'");
$row = mysql_fetch_array($query);
$countN = mysql_num_rows($query);
echo ?>
<body bgcolor="#000000">
<form action="perfil.php?cam=cambia" method="post">
<table width="150" border="0"><tr><td>
<table width="100%" border="0" cellspacing="0" class="bordes">
<tr>
<td height="50" background="fondo_for1.png"><div align="center"><font color="#FFCC00"><strong>Datos
obligatorios</strong></font></div></td>
</tr>
</table>
<table width="99%%" border="0" cellspacing="0" class="bordes">
<tr>
<td><font color="#FFCC00">Nick:</font> </td>
<td> <input type="text" maxlength="20" size="20" name="nick" class="boton2" value="<?= $row['nick']; ?>"></td>
</tr>
<tr>
<td><font color="#FFCC00">Contraseña:</font></td>
<td><input type="password" maxlength="20" name="pass" class="boton2" value="<?= $row['pass'] ?>"> </td>
</tr>
<tr>
<td><font color="#FFCC00">Correo:</font></td>
<td>
<input type="text" maxlength="50" name="mail" class="boton2" value="<?= $row['correo']; ?>"></td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" class="bordes">
<tr>
<td height="50" background="fondo_for1.png"><div align="center"><font color="#FFCC00"><strong>Datos
personales</strong></font></div></td>
</tr>
</table>
<table width="99%%" border="0" cellspacing="0" class="bordes">
<tr>
<td width="44%"><font color="#FFCC00">Nombre:</font></td>
<td width="56%"><input type="text" maxlength="30" name="nombre" class="boton2" value="<?= $row['nombre_real']; ?>"></td>
</tr>
<tr>
<td><font color="#FFCC00">Apellidos:</font></td>
<td><input type="text" maxlength="50" name="apellidos" class="boton2" value="<?= $row['apellidos']; ?>"></td>
</tr>
<tr>
<td><font color="#FFCC00">Edad:</font></td>
<td><input type="text" maxlength="2" name="edad" class="boton2" value="<?= $row['edad']; ?>"></td>
</tr>
<tr>
<td><font color="#FFCC00">Ocupacion:</font></td>
<td><input type="text" name="ocupa" maxlength="50" class="boton2" value="<?= $row['ocupacion']; ?>"></td>
</tr>
<tr>
<td><font color="#FFCC00">Localidad:</font></td>
<td><input type="text" name="loca" maxlength="50" class="boton2" value="<?= $row['localidad']; ?>"></td>
</tr>
<tr>
<td><font color="#FFCC00">Provincia:</font></td>
<td><input type="text" name="provincia" maxlength="50" class="boton2" value="<?= $row['localidad']; ?>"></td>
</tr>
<tr>
<td><font color="#FFCC00">Pais: </font></td>
<td><input type="text" name="pais" maxlength="20" class="boton2" value="<?= $row['provincia']; ?>"></td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" class="bordes">
<tr>
<td height="50" background="fondo_for1.png"><div align="center"><font color="#FFCC00"><strong>Datos
de contacto opcional</strong></font></div></td>
</tr>
</table>
<table width="99%%" border="0" cellspacing="0" class="bordes">
<tr>
<td><font color="#FFCC00">MSN messenger:</font></td>
<td><input type="text" name="msn" maxlength="50" class="boton2" value="<?= $row['msn']; ?>"></td>
</tr>
<tr>
<td><font color="#FFCC00">AOL :</font></td>
<td><input type="text" name="AOL" maxlength="50" class="boton2" value="<?= $row['AOL']; ?>"></td>
</tr>
<tr>
<td><font color="#FFCC00">ICQ:</font> </td>
<td><input type="text" name="ICQ" maxlength="50" class="boton2" value="<?= $row['ICQ']; ?>"></td>
</tr>
</table>
<table width="99%" border="0" cellspacing="0" class="bordes">
<tr><td><div align="center">
<input type="submit" value="Cambiar" align="middle" class="boton">
<input type="reset" value="Restablecer" class="boton">
</div></td></tr>
</table>
</form></td></tr></table>
<? ;
//mysql_free_result($result);
switch($cam){
case cambia:
$host="localhost";
$user="ayuda_web";
$pass="xxx";
$data="ayuda_web";
include("conexiones/conex1.php");
$link=Conectarse($host,$user,$pass,$data);
$query = mysql_query("SELECT * FROM usuarios_pro1 WHERE nick='".$_COOKIE['login']."'");
$row = mysql_fetch_array($query);
$countN = mysql_num_rows($query);
$sSQL="Update usuarios_pro1 Set nick='$nick' pass='$pass' nombre_real='$nombre' apellidos='$apellidos' edad='$edad' naci_dia='$dia' naci_mes='$mes' naci_año='$año' correo='$mail' msn='$msn' AOL='$aol' ICQ='icq' ocupacion='$ocupa' localidad='$loca' pais='$pais' provincia='$provincia'";
$sSQL .= "Where nick='".$_COOKIE['login']."'";
mysql_db_query($sSQL);
mysql_close($link);
break;}
?>
q problema tiene sq cuando le doy a enviar no me hace el update pero tampoco me sale el error unicamente no me updata