Tag Archives: MySQL

Magento: Changing Tax class on all products

Posted on May 3, 2011 by Lukáš Gavenda

I was just asked to update tax classes on products in the catalogue. I found a easy and fast solution.

Posted in Magento | Tagged , , , , , , , | Leave a comment

Google Maps API & PHP+MySQL – working with radius and distance

Posted on June 6, 2010 by Lukáš Gavenda

I needed to find out how to work with Google Geo API in my last project and especially with calculating a radius and distance between two geo points. Another goal was to get a latitude and longtitude from the address … Continue reading →

Posted in Google, PHP & MySQL, Tutorials & guides | Tagged , , , | 1 Comment

MySQL visual database design

Posted on December 4, 2009 by Lukáš Gavenda

I was looking for some nice freeware visual mysql database designer couple of weeks ago. I found two of them: DBDesigner 4 and MySQL Workbench. I must say, that both programs are really very similar, I mean from the view … Continue reading →

Posted in PHP & MySQL | Tagged , , | Leave a comment

MySQL WITH ROLLUP modifier

Posted on November 30, 2009 by Lukáš Gavenda

Yesterday, I was solving simple database Query, where I needed to get some specific data. And while browsing thru MySQL documentation I found a very nice GROUP BY modifier which allows me make less queries and save some CPU on … Continue reading →

Posted in PHP & MySQL | Tagged , | Leave a comment