Select only one random item from each category in MySQL

This tutorial shows how to select items randomly from each category in MySQL. So here I will select exactly one item randomly from each category. People who need sometimes to select photo from each photo category and display them on the page for animation purpose will be benefited. In this example I have used two sample tables with data. You can change the name and column names as per your needs and you will get the same results.

Continue

Read weather information using yahoo API in PHP, MySQL

Many times we see websites that read weather from an RSS feed on another site, here I will show you how to read weather onto your site from Yahoo. Here we will create example on read weather information using yahoo API in php mysql. How to get the XML from To read the weather from Yahoo API, you need to send a request as follows: http://weather.yahooapis.com/forecastrss?p=INXX0028&u=f where p is the location code. In this tutorial I am using “Calcutta/Kolkata, India”, and as you can see the location code or zip…

Continue