' Error

[ChrDav]

Hi,

My site was working fine up until a month or so ago, now whenever I open a page in the editor it converts all my apostrophes to '. Can this be fixed?

Everytime I open the editor I have to fix this up.
An example of my code is below:

$userselect = mysql_query("SELECT * FROM Users WHERE Username= '$username'") or die(mysql_error());

which converts to

$userselect = mysql_query("SELECT * FROM Users WHERE Username= '$username'") or die(mysql_error());

Thanks,
Chris.

[freecrm]

I suspect that this is as a result of copying and pasting.

WYSIWYG Editors like DW automatically convert code when pasted into the design view.

If I'm doing work on the core php, I tend to revert back to notepad!

No editor should convert simply by opening it though!!! :nuts:

You may find the same problems with "&" and a number of other symbols used in php.

[vol7ron]

are you using the html editor or the regular file editor?

[tttony]

its like blogger.com I had problems with the html editor

[xPlozion]

if you have access to the script code, then you can do a str_replace(''', ''', $string); or str_replace(''', '\'', $string); depending on what you want it to show. the first one will create an apostrophe using the html code &apos, while the second one will just display an apostrophe in the source, which will be displayed as an apostrophe on the page

[mfurqanabid]

use WYSIWYG Editor, Like FrontPage, Dreamweaver etc.

[xPlozion]

oh, misread your op. just do a search and replace for ' to '. since this is happening in the php code, my first post is useless.

[ChrDav]

It doesn't matter whether I open it in the code editor or the HTML editor, it still happens. I change it, then next time I open the file for editing it changes back. I know that I can do the search and replace, however everytime I open the file I have to do it again and this gets extremely annoying. You can't use search and replace in the HTML editor which is extremely annoying.

Pasting or typing it manually will make no difference.

This never used to occur until sometime in the last month so maybe something has changed with the servers?

If I use an external editor, everytime I want to look at my page I have to upload it to the server once again. I do a lot of change something small, reload the page to check it did exactly what I wanted it to do, so this just becomes impractical.

[xPlozion]

If I use an external editor, everytime I want to look at my page I have to upload it to the server once again. I do a lot of change something small, reload the page to check it did exactly what I wanted it to do, so this just becomes impractical.

I do the same as you.

What software are you using that this has problems with? this could have a number of causes, either with the ftp client, the software, or the server (although i doubt it's the server). I'll take a look at google to see if i can come up w/ anything.


WAIT!!!
looking at your op, i'm under the impression that you are using cpanels built-in editor. I would highly suggest using another program to edit with.

I'm currently using zend studio 6, but that costs money. You can also use aptana studio or eclipse, both of which are free. With them includes a built in ftp client so you don't need an external one (filezilla, cuteftp, etc...)

[ChrDav]

What do you mean by what software am I using?