Text Problem

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
parko7
Forum Newbie
Posts: 3
Joined: Wed Oct 10, 2007 5:44 am

Text Problem

Post by parko7 »

I have a HTML form that takes text from a text field and stores it into a database not a problem, the problem occurs when i retrieve the text from the database and try to store it again. The variable that holds the text will not store but if i change what the variable holds it will store, so i know its not a problem in my code.

Basically i want to move the text in one field into an archived field in the database, but it wont let me store the text again.

Can anyone help?
parko7
Forum Newbie
Posts: 3
Joined: Wed Oct 10, 2007 5:44 am

Post by parko7 »

its because its got and apostrophe in it!
User avatar
Zoxive
Forum Regular
Posts: 974
Joined: Fri Apr 01, 2005 4:37 pm
Location: Bay City, Michigan

Post by Zoxive »

parko7 wrote:its because its got and apostrophe in it!
Sounds like you need to start validating user input.
parko7
Forum Newbie
Posts: 3
Joined: Wed Oct 10, 2007 5:44 am

Post by parko7 »

problem solved!
Post Reply