Hello pros,
This is a dumb question I know, but I still can't figure it out here.
Basically, I have a page that is spitting out the latest 3 DVD Easter Eggs from my database:
http://www.lightsoutentertainment.com/dvd/eggs/index.php
Here the code:
<?PHP
echo "<table width='65%' border='0' cellspacing='0' cellpadding='5' align='center'>";
$sql = "SELECT D.dvdId, D.title, E.title ";
$sql.= "FROM Dvds D, Eggs E ";
$sql.= "WHERE D.dvdId = E.dvdId ";
$sql.= "ORDER BY E.date DESC ";
$sql.= "LIMIT 1";
$res = mysql_query( $sql );
while ( $arr = mysql_fetch_row($res) )
{
echo "<tr><td width='0%'><a href=\"dvd.php?DvdId=$arr[0]\" class='dvdimages'><img src='/dvd/images/$arr[0].jpg' border='1' ></a></td><td width='100%'><a href=\"dvd.php?DvdId=$arr[0]\" class='main'>$arr[1]</a><br><b>Secret Revealed:</b> $arr[2]</td></tr>";
}
echo "</table>";
?>
Now, I'm looking for it to look like this:
http://www.lightsoutentertainment.com/dvd/eggs/index2.php
How could I modify my code above and do this?
Please help!
Thanks,
Brian
