"; echo " "; echo " "; echo "

"; echo " "; echo " Recently Added Songs"; echo " "; echo " "; echo " "; $db->open("SELECT * from songlist WHERE songtype='S' ORDER BY date_added DESC LIMIT 20"); $count = 1; while($row = $db->row()) { $count++; if(($count % 2)== 0) { echo ""; echo " "; if (empty($row["picture"])) $row["picture"]="na.gif"; echo " "; echo " SONG: ".$row["title"]."
"; echo " ARTIST: ".$row["artist"]."
"; echo " ALBUM: ".$row["album"]."
"; echo " RELEASED: ".$row["albumyear"]." ADDED: ".substr($row["date_added"],5,2)."/".substr($row["date_added"],8,2).""; echo " "; } else { echo " "; if (empty($row["picture"])) $row["picture"]="na.gif"; echo " "; echo " SONG: ".$row["title"]."
"; echo " ARTIST: ".$row["artist"]."
"; echo " ALBUM: ".$row["album"]."
"; echo " RELEASED: ".$row["albumyear"]." ADDED: ".substr($row["date_added"],5,2)."/".substr($row["date_added"],8,2).""; echo " "; echo ""; } } echo ""; ?>