Hi there I have the following code.
<script language="text/javascript">
banner1 = new Banner('banner1');
<?php
$con = mysql_connect("localhost:3306","User","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("text","';
echo $row['ArtistDate'];
echo '" , ,,, ';
echo '"';
echo $row['ImgLink'];
echo '"';
echo ');';
}
mysql_close($con);
?>
document.write(banner1);
banner1.start();
</script>
What i am trying to do is add the Date for the banner below the image. It displays the rotation of the images perfectly without modification but when i add the date from the database it does not show the images nor the text. To see a working copy of this please go to www.thebarninsanford.com. The rotating banner on the right of the main page is what im working on. I am trying to reuse images and just have the show date appear under the images. Any help would be aprechiated!!
Thanks