Unique Email Address in Mysql

I have a big mail database but there are some dublicate email addresses. I need unique email address lists and i follow this way; Firstly i create temporary table for unique email address After i add unique email address to that temp table I dropped my real email table After all, i create new mail …

Continue reading

Select Users Age in MySQL

SELECT count(id) AS toplam,YEAR(tarih_dogum) AS YIL FROM uyeler GROUP BY YEAR(tarih_dogum) Advertising agencies wants to user profile for advertisements. I need my users age. I found a little solution. I write this SQL statement for select which year my users born and group them. After i copied this results to Excel. I calculate age groups …

Continue reading

Php 5.2.9 Updated But Mysql Doesnt Work

I blogged Php 5.2.9 Upgrade. Some of my user updated with using this entry. But i miss something in these entry. Firstly, i have to say. If you upgrade php version, you have to upgrade mysql and php-mysql. To Upgrade Mysql and Php-Mysql tool And there one more thing, he was php4 and upgrade to …

Continue reading

Creating Google Sitemap in PHP

We can create dynamic sitemap with using PHP & Mysql. My example code is easy to apply your system. Google Sitemap Plugins for WordPress http://www.dicontas.co.uk/blog/google-sitemap-utw-tag-wordpress-plugin/ http://www.arnebrachhold.de/redir/sitemap-home/ http://www.karailiev.net/karailievs-sitemap/ http://southcoastwebsites.co.uk/wordpress/

Continue reading

Calculate Last Week, Last Month in Mysql

We need get datas from last week, last month, yesterday and today. We can do it easily in MySQL. Getting Current Date Result : 2009-06-04 Getting Last Week Datas Getting Last Month Datas Getting Last Year Datas And Php example for this calculations, getting last month orders For more information of Date and time functions …

Continue reading

Forgot WordPress Admin Password

Firstly; you need access to your MySQL Server and maybe access to your wp-config.php file in the root of your site. Go www.md5-creator.com and type in a password you want to use.Example type “123” then copy. “123 in MD5 :” ‘s result is “202cb962ac59075b964b07152d234b70” Than open your MySQL database, and click the wp_users table Change …

Continue reading