[RESOLVED] Storing long text problem.

CybJunior

Hi,
I'm trying to store for example two text pages in a field which is assigned as lontext but it wont save it there. I tried with two - three paragraphs and it works fine, what can the problem be?
Alexey

scrupul0us

http://help.scibit.com/Mascon/masconMySQL_Field_Types.html

invalid characters? can we see what u are trying to store?

CybJunior

That's text in russain, i don't think its realy a good idea to post it here.
I tried with just one line of this text and it works fine but when its one page nothing comes out. What could it be then?

CybJunior

now i've changed the code a bit and it has to add the text but it still doesn't.
When i "echo" the query it seems that everythings ok, but still no result in database.
The query is

$query = "UPDATE `do_page` SET description='".$sValue."' WHERE key_id='".$key_phrase."')"; 
  $result = mysql_query($query);

Is everything correct here?

CybJunior

found - a goddam bracket at the and of the query...

CybJunior

found the error wich stoped the script from updating there are ' symbols in the text.
Is there any function that can remove them from the text before running the query?

scrupul0us

just escape them using addslashes() or use ereg_replace and regex them out

as for russian text... looks like english to me

CybJunior

Please change my user name to something else and delete my account.

bradgrafelman

CybJunior;10997519 wrote:
Please change my user name to something else and delete my account.

Well for one, you'd want to post something like this in the Feedback forum or perhaps even by using the Contact Us form.

But also note that unless the current administration has changed its policy, the previous policy was to:

Not delete accounts.
Not honor rename requests unless it could be demonstrated that the user accidentally used the their "real" legal name when originally registering.