DB Not Updating
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?
Thanks,
Ray
Subject
Written By
Posted
DB Not Updating
March 21, 2024 04:57PM
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.