Php/MySQL database insert record issue...

[charmac2013]

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.

[charmac2013]

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?

[Ben M]

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.