<?
// open database connection
$connection = mysql_connect($host, $user, $pass) or die ("Unable to connect!");
// select database
mysql_select_db($db) or die ("Unable to select database!");
// generate and execute query
$query = "SELECT id, title, brief, timestamp FROM news ORDER BY timestamp DESC LIMIT 0, 3";
$query2 = "SELECT id, band, music, timestamp FROM songs ORDER BY timestamp DESC";
$result = mysql_query($query) or die ("Error in query: $query. " . mysql_error());
$result2 = mysql_query($query2) or die ("Error in query: $query2. " . mysql_error());
// if records present
if (mysql_num_rows($result) > 0)
{
while($row = mysql_fetch_object($result))
{
if (mysql_num_rows($result2) > 0)
{
while($row2 = mysql_fetch_object($result2))
{
?>
