"; echo "\n"; ?> =\''.$getdate.'\' ORDER BY RAND(NOW())'; $result = mysql_query($query) or die('Query failed: ' . mysql_error()); // Printing results in HTML echo "\n"; while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) { echo "\t\n"; $fileURL=$line["file"]; $location=$line["location"]; $name=$line["name"]; $albumURL=$line["href"]; echo "\n"; echo "\t\n"; } echo "

\n"; echo "" . $name; echo " "; if ($albumURL!='NULL'){ echo "(buy album)";} echo "

\n"; // Free resultset mysql_free_result($result); // Closing connection mysql_close($link); ?>