This tutorial shows how to select items randomly from each category in MySQL. So here we 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. Continue reading “Select only one random item from each category in 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:
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 code is INXX0028, if you live in the USA you can just use the ZIP code where you live in. Next, ‘u’ is the unit in which the weather must be displayed, I chose ‘f’ for Fahrenheit, but if you want, you can also choose ‘c’ for Celsius. Continue reading “Read weather information using yahoo API in PHP, MySQL”