[Resolved] problem with an UPDATE query

[cryptangel]

Hi there.
I've been having a problem with an UPDATE query in my page. This are the instructions that I' using to get this to work, but doesn't get results, not even error messages.

Code:

<?php
// Retrieve values
$nc = $_POST["nc"];
$edo_civil = $_POST["ec"];
// Get connection to DB
$conn = mysql_connect("localhost","root","proyecto")or die("No se puede establecer la conexion");
// Selecting database
mysql_select_db("ITCHII_EGR",$conn);
// Forming the query
$ssql = "UPDATE t_alumnos SET edo_civil='$edo_civil' WHERE = '$nc'";
// Executing query
mysql_query($ssql,$conn);
// Shows results
$cuantos = mysql_affected_rows();
echo "modificados: $cuantos<br>";
// Close connection
mysql_close($conn);
?>

Anyone knows why is this?

[eoghain]

You are missing the column to compair your $nc value to in your SQL statement:

$ssql = "UPDATE t_alumnos SET edo_civil='$edo_civil' WHERE = '$nc'"; 

It should be something like this:

$ssql = "UPDATE t_alumnos SET edo_civil='$edo_civil' WHERE field1 = '$nc'"; 

[cryptangel]

:o :o :o :o Man, I'm ashamed of myself :o :o :o :o

I can't believe I let that kind of error to happen. And besides, the 3 guys I had to look at the code never noticed nothing amiss with the SQL instruction.

Thanks eoghain, and sorry about that 😛