http://www.bluesfanclub.net Blues Fan Club ry:n uutisotsikot fi http://www.bluesfanclub.net PHP/$phpversion END; // loop through the array pulling database fields for each item for ($i = 0; $i < mysql_num_rows($result1); $i++) { @$row = mysql_fetch_array($result1); $title = cleanText($row["otsikko"]); $link = "http://www.bluesfanclub.net/cgi-bin/fcweb2007/uutiset.pl?alaluokka=" . $row["kategoria"] . "&id=" . $row["id"]; $description = cleanText($row["uutinen"]); $guid = "".$row["id"]; $pubDate = date("r", strtotime($row["aika"])); // display an item ECHO << $link $description $pubDate $guid END; } ECHO << END; ?>