URL in mysql database

I upload url links from excel to mysql database.

Then email out the data, but the urls look like script in the email

How do you keep in a url link during the process.

<a href="http://www.google.com" target="new">Google</a>

Thanks

 

I'm not sure I understand, do you think that you may provide some more details or possibly re-word the question.

Thanks,

 

My database is on Excel.

I upload it using a mysql uploader to my mysql database

I have a php script email out the data.

In the email sent out from mysql database my links are not links but text.

<a href="http://www.google.com" target="new">Google</a>

Is it in the setting of the mysql database or do you have to write the link different.

Thanks

 

Perhaps maybe you should try using a loop to write the links into an actual link.

 

I placed the url in the mysql but still when it emails out it does not work.

[WebService(Namespace = "http://google")]

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

Nothing works.

I have even tried importing and setting the field to "varchar" hoping this will work.

Does anyone have any ideas on how to get this to work properly

Thanks

 

Ok.

I think this may be to much work to do when I want to update my database

would inserting a clickable URL LINK in the body of my php page work better

 

Can anyone tell me How to do this;
When i give the URL to the application it should go to that url and that program should scrap the data from that site! (like title and body and so and so)

Thank you

 

When you are emailing out the data, you need to send the email as HTML and not text. By sending in straight text, it will not format your URL's properly.