I recently received an email from Text Link Ads (TLA) that they are now using the “tinyrul” URL. If you are member of the TLA Publishers then, I’m sure you received similar email from TLA.
So, it’s now time to change the URL’s that you’d used on your posts in linking back to your TLA Affiliate URL, and that will be time consuming job. However, there are options that you can use to make it easy:
- By going directly to your SQL database and change the old TLA URL into the new one. Yuga has this tip:
- If you’re familiar with PHPMyAdmin in your cPanel, you can do a lookup command via SQL:
SELECT * FROM ‘wp_posts’ WHERE post_content LIKE ‘%http://www.text-link-ads.com/?ref=10549%’
Or you can do the update directly from there using this sample SQL query:
UPDATE `wp_posts` SET `post_content` = REPLACE(`post_content`, “http://www.text-link-ads.com/?ref=10549″, “http://tinyurl.com/2nwm9u”)
Again, don’t forget to use your own affiliate links.
- If you’re familiar with PHPMyAdmin in your cPanel, you can do a lookup command via SQL:
- Create a page that will redirect your users to the affiliates pages, and link to this page everytime you mention a particular affiliate. John Chow taught us this already. Visit his post, “Hiding Affiliate Links for Better SEO” and learn how to employ this technique into your blog.
- You can easily change the URL by using the “Search and Replace Plugin” for your wordpress-self hosted blog. This was suggested by .
The Reason for using the TinyURL
I am currently wondering why TLA is now using the “TinyURL” URL. But I guess, it’s because Google and other search engines hate paid links.
Well. If you know the real reason, please comment about it.
| 2.8 |

SELaplana, 26 August 2007 at 




August 26th, 2007 at 4:40 am
Thank you for sharing this. I should consider using that pala for ads na. Hmm…
August 28th, 2007 at 2:19 pm
welcome po.
August 29th, 2007 at 7:56 pm
[...] TinyURL for TLA Affiliate URL [...]