I have the following code...
<?php
$con = mysql_connect("localhost:3306","name","pass");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("barndata", $con);
$today = date("Y-m-d");
$result = mysql_query("SELECT * FROM event where Date >= '$today' ORDER BY Date ASC LIMIT 0, 7") ;
while ($row = mysql_fetch_array($result)) {
echo 'banner1.add("IMAGE","';
echo $row['ImagePath'];
echo '" , 5, 270, 420, ';
echo '"';
echo $row['ImgLink'];
echo '"';
echo ');';
}
mysql_close($con);
?>
document.write(banner1);
banner1.start();
</script>
I am attempting to add a date under the image so i added the following
echo $row['ImgLink'];
echo '"';
ADDED THIS Line.-------> echo $row['ArtistDate'];
echo ');';
and it doesnt work. anyone have a idea how to fix it? im sure its simple and im overlooking but im not seeing it.
Anyhow it shows a image and im looking to add the date below that image for each picture that is shown..
Thanks