Tag ‘search’ » Archiv


Guest blogging brings great results at ComLuv.com


Why guest blogging on ComLuv.com

I’ve just finished making a video presentation explaining why guest blogging really works, especially if you do it in the right place!

[youtube clip_id="-Gj-YGKzASg"]

In the video, you see how Jane Sheeba of Find All Answers blog got a page 1 on Google for a term that has over 1.2 Billion results for her guest post on how to do business on facebook

Over the moon!

It’s not just Jane, lots of guest bloggers are over the moon with their search results! there are multiple page 1 results for some very popular terms.

I’m about to embark on the coding of the premium CommentLuv so I wont have time to make many blog posts so it’s a perfect time to encourage people to write them on ComLuv.com which helps me and helps them. awesome.

what do you think of the video?

video blogging


How to do a mass text search and replace with MySQL


I noticed that all my images on the posts here weren’t showing and it was because the url to their location was still pointing at the sub blog on The Comluv Network so I needed a way to edit the database to update the url to point to the files held here.

Easy with a REPLACE function on the wp_posts table.

You just need 3 things for the replace command :

  1. The row you’re altering
  2. The string you’re searching for
  3. The string you’re replacing with

UPDATE `wp_posts` SET `post_content` = REPLACE( `post_content` , "fiddyp.comluv.com/files/", "fiddyp.co.uk/wp-content/uploads/" )

It did the whole table of posts in less than a second. Sweet, now all my images are back to normal on this site.

Code, PHP