hello all,
Complete noob when it comes to PHP and MYSQL anyway I have put a series of images in my database, when trying to retrieve the images I just get a page of binary.
<?PHP
$link = mysql_connect("****","*****","");
mysql_select_db("***");
$query = "SELECT image,year,image_name,description FROM gallery";
$results = mysql_query($query);
echo "<?xml version=\"1.0\"?>\n";
echo "<images>\n";
while($line = mysql_fetch_array($results)) {
echo "<photo>" . $line["image"] . $line["image_name"] . $line["year"]. $line["description"] . "</photo> \n";
}
echo "</images>\n";
mysql_close($link);
?>
Anyone know what the issue could be?
Thanks all