MySQL Forums
Forum List  »  Newbie

DB Not Updating
Posted by: Raymond Jender
Date: March 21, 2024 04:57PM

I have a table that consists of 20 columns.
One of the columns is not updating.
Here is the HTML form info:

<input id="element_15" name="element_15" class="element text medium" type="text" maxlength="18" name="propertypin" />

My php is: $propertypin = ($_POST['propertypin']);

And finally the sql: "INSERT INTO `orderform` ( propertypin ) VALUES ('$propertypin')";

There are about 18 other fields being stored correctly, so I'm just showing the one that is not updating.

Initially. the propertypin format was in this format: 12 34 567 890 1111 and I stored each set of digits in a separate fields. However, now I want to store the entire set of numbers as one field in the db. The above sql however is not updating the db.

The propertypin in the orederform table is described as such:

Field | Type |Null |Key |Default |Extra |
propertypin | varchar(20) | YES | |NULL | |

The Table has nothing in the propertypin column. It's blank.

Any ideas what the problem could be?



Options: ReplyQuote

Written By
DB Not Updating
March 21, 2024 04:57PM
March 21, 2024 10:43PM
March 22, 2024 07:45AM
March 22, 2024 09:02PM
March 22, 2024 11:47AM

Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.