This is what im trying to do. I qwery the database for 7 events and im attempting to do a rotating banner with link and a caption. However being new to this php coding im having issues with my echo statements. The title Tag is my caption. Im attempting to use nivo-slider and modify for my needs if your unfamilliar with it the website for it is http://nivo.dev7studios.com/. Im preety sure im close to fulilling my needs if I cant get a push over the hill it would be great. Been working on this stuff for 3 days with no avail.
Thanks so Much!!!
<?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 "<img src=";
echo . $row['ImagePath'] . ;
echo "alt=;
echo "Country Music Nightclub Orlando";
echo " ";
echo "Title=" . $row['ArtistDate'] .";
echo " /></a>";
}
mysql_close($con);
?>