Magento execute custom query

How to magento execute custom query?In here you can execute custom query to insert,update,delete and fetch data from database with using magento existing database connection.

Magento get order increment id

How can you get order increment id/last order id in magento? You can get magento order increment id/last order id into the success.phtml page by this method.Also you can get magento order increment…

Magento reset admin password

If you can’t log into the admin panel or can’t remember admin password you can reset/change admin password like this method.Log into the database and run the following query of it.

Magento get all URL paths

Here,simple scripts to get store url, media url, skin url, site url, js url, current page url, site url in magento.You can use these methods in your phtml files in magento.