apostrophes

[phpretard]

I am pulling info from a DB and emailing it based on variable names.

 

Randal's Appraisals, LLC <--EXAMPLE

 

When it gets emailed the company name stops at the apostrophe.

 

So the "From" Line in the Email reads "Randal".

 

Any other company names works great. 

 

So I guess the question is how can I get the PHP variable to (for lack of better words) ignore and still print the apostrophe?

 

I think the only real significant script is:

 

$mail->FromName   = "$CompanyName";

 

If you need more please let me know...

 

Thanks.

 

[phpretard]

Should I addslashes when I call it from the DB?

 

It is in the DB just like this--> Randal's Appraisals, LLC

[phpretard]

Should I add/strip slashes when putting text into the DB or pulling them out?

 

I have read into this...just need a little help here.

[Mchl]

You should run mysql_real_escape_string() on data before you insert it into database

[phpretard]

OK.

 

But when I try to use it in a "FROM" line in an email it stops where the apostrophe starts.

 

any thoughts there?

 

So instead of being FROM - Randal's Appraisals, LLC

 

It is FROM - Randal

 

 

[Mchl]

addslashes()

[kenrbnsn]

How are you displaying the output?

 

Addslashes() will not work if this is being displayed to the browser. When displaying data to the browser you should use htmlentities().

 

Ken

[phpretard]

I am displaying it in the "From" Line in an email.

 

$CompanyName="Randal's Appraisals, LLC";

 

$mail->FromName  = "$CompanyName";

[phpretard]

This does not do what it says...

 

$str = "A 'quote' is <b>bold</b>";

// Outputs: A 'quote' is <b>bold</b>
echo htmlentities($str);

echo "<br><br>";

// Outputs: A &#039;quote&#039; is <b>bold</b>
echo htmlentities($str, ENT_QUOTES);