Archive for the “sql” category

How to manually update your WordPress login

by Jean-Baptiste Jung on March 29, 2011

If you need to change your WordPress login, the easier is to use PhpMyAdmin and execute a simple SQL query to update it. Here’s a quick recipe to show you how to proceed.

Looking for WordPress hosting? Try WP Web Host. Prices starts at $5/month and you can try it for free!

How to manually update your WordPress login

WordPress tip: Get rid of unused post revisions

by Jean-Baptiste Jung on March 9, 2010

WordPress have a feature which saves various copies of your posts in order to allow you to compare revisions or restore an older version of your posts. This is very useful, but it also take a lot of space in your database. Here is a very handy SQL query that will instantly delete all posts revisions as well as meta associated with it.

Looking for WordPress hosting? Try WP Web Host. Prices starts at $5/month and you can try it for free!

WordPress tip: Get rid of unused post revisions

WordPress trick: Change theme programatically

by Jean-Baptiste Jung on February 21, 2010

In WordPress, changing themes are easy. But what when you have to change a theme programmatically? Just read the following recipe to find out. It’s a lot easier than you may think!

Looking for WordPress hosting? Try WP Web Host. Prices starts at $5/month and you can try it for free!

WordPress trick: Change theme programatically

WordPress trick: Change theme programatically

by Jean-Baptiste Jung on February 21, 2010

In WordPress, changing themes are easy. But what when you have to change a theme programmatically? Just read the following recipe to find out. It’s a lot easier than you may think!

Looking for WordPress hosting? Try WP Web Host. Prices starts at $5/month and you can try it for free!

WordPress trick: Change theme programatically

WordPress trick: function to get tags related to category

by Jean-Baptiste Jung on October 12, 2009

Do you ever wanted to be able to get tags related to one (or more) specific category? If yes, I’m pretty sure you’ll be delighted with this very cool tip.

Looking for WordPress hosting? Try WP Web Host. Prices starts at $5/month and you can try it for free!

WordPress trick: function to get tags related to category