Coding help

[RON_ron]

I'm trying to update a field in my MySQL but instead of updating this makes the field BLANK.

 

my code:

$SomeVar = $_POST['finco'];
mysql_query("UPDATE  c_applicants SET streetz='$cts' WHERE username = '".$SomeVar."'");

$result = mysql_query($query);

[Adam]

Try:

 

$sql = "UPDATE c_applicants SET streetz='" . $cts . "' WHERE username = '" . $SomeVar . "'";
$query = mysql_query($sql) or trigger_error('MySQL Error: ' . mysql_error(), E_USER_ERROR);

 

Also remove the second mysql_query() call. If you don't get any errors, echo out $sql and make sure the values are valid. If they appear valid, it's still possible they're incorrect.. which you can verify with mysql_affected_rows, or by running the SQL in a MySQL administrator (i.e. PHPMyAdmin) to find the number of rows affected.

[RON_ron]

Thanks Mr.Adam...

 

When a field is updated it goes blank... ? What might be the issue here?

[revraz]

You are doing it twice and the 2nd time it blanks it out.

[RON_ron]

Hi revraz.

 

But that's my code.. why did you say it's being updated twice? How can I correct this?

[trq]

Where is $cts defined?

[RON_ron]

that comes externally.

[trq]

Well, it appears to be empty.