Echo '&" symbol?

[Dolemite50]

Hi,
I tried searching on ampersand and couldnt find an answer and "&" was too short of a word to query here.

I just need to know how to echo an entry that is in the DB with an & symbol

For example "Bonnie & Clyde"

Displays as "Bonnie &amp Clyde"

I have verified that the entry in mysql says "Bonnie & Clyde".

Thanks alot.

[gardnc]

I wold suggest you replace each instance of "&" with "\&".

Larry

[Dolemite50]

So change it in the mysql DB?

Also, if I do, how can I be assured that all entried will go in that way?

Thanks alot.

[Dolemite50]

I added the slash in mysql and it didnt work so you must be referring to replacing it on the output somehow? Can you please give me an example?

[LordShryku]

Sounds like you're using htmlentities or htmlspecialchars, which is a good thing. The &amp just needs a ; on the end of it, which is the html entity for a an ampersand.

[Dolemite50]

Hi,

in order to post it on the board I had to remove the ; at the end or it would only display the "&".

It echoes with &amp <--- with ; at the end. I am trying to figure out how to get rid of the whole amp ; part so that it just echoes as "&".

[Dolemite50]

In other words, i have a column in my mysql db that says "Bonnie & Clyde".

When I select it in a php statement and echo it on a page it displays as "Bonnie &amp ; Clyde". (w/o a space after &amp).

[Dolemite50]

I cant believe I cant find an answer to this, it seems like it would be so simple. I tried urldecode, rawurldecode, stripslashes, and many more but still cannot get the ampersand to display without the amp; after it. I dont need to pass it thru a url or anything, any suggestions?

[LordShryku]

Are you using htmlentities or htmlspecialchars on it? Mind showing us the code?

[Dolemite50]

Thanks again,

I've been using some functions that laserlight graciously supplied:

function prepIn($input) {
$input = trim($input); 
if (!get_magic_quotes_gpc()) {
return addslashes($input); 
} 
return $input; 
} 


function prepOut($input) { 
 $input = stripslashes($input); 
return htmlspecialchars($input); 
}

I use prepIn going into the the DB. After doing so the & symbol shows as just a normal & symbol when I browse in phpmyadmin.

I use a normal SELECT statement to retrieve it, and then I tried prepOut on it but after doing so it shows with &amp ;. I then tried removing the prepOut() on the output but it still shows as &amp ;

Then I tried urldecode and several others but just cant it to display as an ampersand. ?????

[laserlight]

and then I tried prepOut on it but after doing so it shows with &amp ;. I then tried removing the prepOut() on the output but it still shows as &amp ;

hmm... that's strange, did you somehow also store it in htmlspecialchars() form after that?