[RESOLVED] URL stored in meduiumtext block truncating text

dmacman1962

Hi all,

I have a mediumtext block that has some URLs stored along with the text and I am trying to echo the text. But it truncates all the text before the Href.

Here is the text as it is stored in my table in the ShortDescription field as...

For a limited time only, we are able to offer teachers three of our new programs on DVD format and a free DVD player! The programs include: <a href=\"http://www.intheclassroom.org/products/index.php#1039\">The Price System</a>, In the Classroom with David Robinson, and The Foundations of Wealth.

And my code to display the text.

echo ($row['ShortDescription']);

But all I get is ....

The Price System, In the Classroom with David Robinson, and The Foundations of Wealth.

Do I have to urlencode the text coming FROM the database???

Thanks,

Don

herve

Have you look the source code of the resulting HTML page ? What's inside exactly ?

dmacman1962

Hi herve,

In the HTML source code, it drops everything before...

For a limited time only, we are able to offer teachers three of our new programs on DVD format and a free DVD player! The programs include:

The Price System, In the Classroom with David Robinson, and The Foundations of Wealth.

In the table the field contains the following...

For a limited time only, we are able to offer teachers three of our new programs on DVD format and a free DVD player! The programs include: <a href=\"http://www.intheclassroom.org/products/index.php#1039\">The Price System</a>, In the Classroom with David Robinson, and The Foundations of Wealth.

The second block of text should include the hyperlink for "The Price System" but it drops the <a href and the </a> at the end. IE, it is 'stripping them out."

Does that shine some more light on it?

Thanks,

Don

herve

Not really I'm afraid 🙂

It's really strange.

What's happening if you use this code :

$text = $row["ShortDescription"];
print "###$text###";

I put extra "###" just to be sure to see every character (like Carriage Return)

If it does'nt work, we need to see more of your code,
especially the code between the SQL query and the "echo" call.

dmacman1962

Hi herve,

I found the problem with your help. I accidentally had the second quote " mark after the name in the link, instead of closing the url.

<a href="http://www.google.com>Goggle"</a>

Which is why I was getting the strange results.

Your

print "###$text###";

helped me spot it.

I totally missed that typo.

Thanks a lot.

Don

herve

Happy for you 😉