Skip to main content
C
charmac2013
Known Participant
February 21, 2012
Question

Php/MySQL database insert record issue...

  • February 21, 2012
  • 1 reply
  • 539 views

I have a php page that adds an "order" to a mysql database table (orders). One text field in the form is for tires/wheels. The description of the wheels often includes the " symbol for inches after a number....Everything submits fine, however when I look at the page that displays the orders all the data after the " symbol including the " symbol is gone... DOes anyone have any idea why this may be happening? It is requiring us to return and edit that area repeatedly. Any help is appreciated greatly. Thanks for your time.

This topic has been closed for replies.

1 reply

C
charmac2013Author
Known Participant
February 21, 2012

CORRECTION.... All the data is getting into the database however I am displaying it on the next page in a textbox and it is only displaying the data untill the " symbol. Any ideas?

B
Community Expert
Ben MCommunity Expert
Community Expert
February 21, 2012

Ok, so just to summarize so I am understanding this correctly.  You have an ordering page for tires/wheels.  A customer places an order for tires/wheels and the data is submitted successfully and this includes a symbol for measurement (in.).  But on another summary page the symbol is returning a blank value.

If this is correct we need to see:

- First, the code that is inserting the symbol to the database table in question

- Second, the query and code where you are printing the data to the screen.

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices