Skip to main content
Known Participant
February 21, 2012
質問

Php/MySQL database insert record issue...

  • February 21, 2012
  • 返信数 1.
  • 544 ビュー

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.

このトピックへの返信は締め切られました。

返信数 1

charmac2013作成者
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?

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.