Here is the code for my page:

<?
session_start();
?>
<html>

        <head>
                <meta http-equiv="content-type" 
content="text/html;charset=ISO-8859-1">
                <meta name="generator" content="Adobe GoLive" />
                <title><?
mysql_connect('x', 'x', 'x');

mysql_select_db('x');

$hdrquery = "SELECT *
                        FROM productions
                        WHERE prodid = $var";
$hdrresult = mysql_query($hdrquery) or die(mysql_error());

while ($hdr = mysql_fetch_array($hdrresult))
{
print $hdr["prodtitle"].' ['.$hdr["market"].' (';

                        if(9999==$hdr["open_yr"])
                        {
                        print 'unknown';
                        }
                        else
                        {
                        print $hdr["open_yr"];
                        }

                        if(!empty($hdr["numeral"]))
                        {
                        print ' ('.$hdr["numeral"].')';
                        }

print ')]';
}
?> [overview]</title>
                <link href="../../css/basic.css" type="text/css" 
rel="stylesheet" media="all" />
                <link href="../../css/back.css" rel="stylesheet" 
type="text/css" media="all">
        </head>

        <body>
                <div align="center">
                        <div align="left">
                                <form id="FormName" action="../../results.php" 
method="post" 
name="FormName">
                                        <div align="center">
                                                <table width="800" border="0" 
cellspacing="0" 
cellpadding="0">
                                                        <tr>
                                                                <td 
align="right" valign="bottom">
                                                                        <table 
border="0" cellspacing="0" 
cellpadding="2">
                                                                                
<tr>
                                                                                
        <td><? include("../../include/
account.php");
?></td>
                                                                                
</tr>
                                                                        </table>
                                                                </td>
                                                        </tr>
                                                        <tr>
                                                                <td 
align="right" valign="bottom"><font 
color="#c7ddf3"><img src="../../img/common/header.gif" alt="" height="125" 
width="800" border="0"></font></td>
                                                        </tr>
                                                        <tr height="5">
                                                                <td 
bgcolor="#afafaf" height="5"><? include
("../../include/headernav.php");
?></td>
                                                        </tr>
                                                        <tr>
                                                                <td 
bgcolor="white">
                                                                        <table 
width="800" border="0" 
cellspacing="0" cellpadding="0">
                                                                                
<tr>
                                                                                
        <td>
                                                                                
                <table width="800" 
border="0" cellspacing="0" cellpadding="0" bgcolor="#e0e0e0" height="457">
                                                                                
                
        <tr height="75">
                                                                                
                
                <td colspan="2" align="left" valign="bottom" height="75"><?
print '<table width="800" border="0" cellspacing="0" cellpadding="3" 
height="75">
                        <tr>
                                <td align="right" valign="top"><!--favorites 
here--></td>
                        </tr>
                        <tr>
                                <td valign="bottom">';

mysql_connect('x', 'x', 'x');

mysql_select_db('x');

$prodquery = "SELECT *
                                FROM productions
                                WHERE prodid = $var";
$prodresult = mysql_query($prodquery) or die(mysql_error());

while ($prod = mysql_fetch_array($prodresult))
{
print '<span class="header">'.$prod["prodtitle"].'</span> (<span 
class="subhead">'.
$prod['tag'].', ';
                                                                                
                                                                                
        if(9999==$prod['open_yr'])
                                                                                
        {
                                                                                
        print 'unknown';
                                                                                
        }
                                                                                
        else
                                                                                
        {
                                                                                
        print $prod['open_yr'];
                                                                                
        }       
                                                                        
                                                                                
print ')</span>';


}


print '                 </td>
                        </tr>
                </table>';
?></td>
                                                                                
                
        </tr>
                                                                                
                
        <tr>
                                                                                
                
                <td valign="top" width="250"><?
mysql_connect('x', 'x', 'x');

mysql_select_db('x');

// IMAGE

        print '<p align="center">';
        
        $imagequery = "SELECT *
                                        FROM productions_art
                                        WHERE prodnu = $var AND front = 'X'";
        $imageresult = mysql_query($imagequery) or die(mysql_error());
        $imagerows = mysql_num_rows($imageresult);

        if(0<>$imagerows)
        {
        while ($image = mysql_fetch_array($imageresult))
        {
        print '<a 
href="promo.php?image='.$image["galleryid"].'&var='.$var.'"><img 
src="http://www.flyrope.com/galleries/production/th_'.$image["file"].'" 
border="0"></
a>';
        }
        
        }
        else
        {
        print '<img src="../../img/dbgraphics/noimage.gif" alt="" height="108" 
width="72" 
border="0" />';
        }

        print '</p>';

// NAV


print '<img src="../../img/dbgraphics/proddetails.gif" alt="" border="0">';

$prodnavquery = "SELECT *
                        FROM productions
                        WHERE prodid = $var";
$prodnavresult = mysql_query($prodnavquery) or die(mysql_error());

print '<table width="175" border="0" cellspacing="0" cellpadding="1">';

while ($prodnav = mysql_fetch_array($prodnavresult))
{
// MAIN

print ' <tr>
                        <td><a href="index.php?var='.$var.'">Main 
Overview</a></td>
                </tr>';

// FULL

print ' <tr>
                        <td><a href="full.php?var='.$var.'">Full Cast & 
Staff</a></td>
                </tr>';

// NOTES

$notesquery = "SELECT *
                        FROM notes
                        WHERE prodno = $var";
$notesresult = mysql_query($notesquery) or die(mysql_error());
$notesrows = mysql_num_rows($notesresult);

print '<tr>
                        <td>';
                        
if(0<>$notesrows)
{
print '<a href="notes.php?var='.$var.'">';
}
else
{
print '<font color="gray">';
}

print 'Production Notes</a></font>
                        </td>
                </tr>';

// AWARDS

$awardquery = "SELECT *
                                FROM awards
                                WHERE prodno = $var";
$awardresult = mysql_query($awardquery) or die(mysql_error());
$awardrows = mysql_num_rows($awardresult);

print '<tr>
                        <td>';
                        
if(0<>$awardrows)
{
print '<a href="awards.php?var='.$var.'">';
}
else
{
print '<font color="gray">';
}

print 'Awards</a></font>
                        </td>
                </tr>';

// PROMO

$galleryquery = "SELECT *
                        FROM productions_art
                        WHERE prodnu = $var";
$galleryresult = mysql_query($galleryquery) or die(mysql_error());
$galleryrows = mysql_num_rows($galleryresult);

print '<tr>
                        <td>';

if(0<>$galleryrows)
{
print '<a href="promo.php?var='.$var.'&image=0">';
}
else
{
print '<font color="gray">';
}

print 'Promotional Art</a></font>
                        </td>
                </tr>';

// SONGS



print '<tr>
                        <td>';

if(0<>$prod['versionnu'])
{
print '<a href="songs.php?var='.$var.'">';
}
else
{
print '<font color="gray">';
}

print 'Songs</a></font>
                        </td>
                </tr>';

// ORCHESTRA

$orchquery = "SELECT *
                        FROM orchestra
                        WHERE production = $var";
$orchresult = mysql_query($orchquery) or die(mysql_error());
$orchrows = mysql_num_rows($orchresult);

print '<tr>
                        <td>';

if(0<>$orchrows)
{
print '<a href="orchestra.php?var='.$var.'">';
}
else
{
print '<font color="gray">';
}

print 'Orchestra</a></font>
                        </td>
                </tr>';

// IMAGES
//<a href="images.php?var='.$var.'">

print ' <tr>
                        <td><font color="gray">Images</font></td>
                </tr>';

// RELATED

$relatedquery = "SELECT *
                        FROM related
                        WHERE relate_from = $var";
$relatedresult = mysql_query($relatedquery) or die(mysql_error());
$relatedrows = mysql_num_rows($relatedresult);

print '<tr>
                        <td>';

if(0<>$relatedrows)
{
print '<a href="related.php?var='.$var.'">';
}
else
{
print '<font color="gray">';
}

print 'Related Productions</a></font>
                        </td>
                </tr>';

// TRYOUT

$tryoutquery = "SELECT *
                                FROM theatres_join
                                WHERE prod = $var AND runtype = 'TR'";
$tryoutresult = mysql_query($tryoutquery) or die(mysql_error());
$tryoutrows = mysql_num_rows($tryoutresult);

print '<tr>
                        <td>';

if(0<>$tryoutrows)
{
print '<a href="tryout.php?var='.$var.'">';
}
else
{
print '<font color="gray">';
}

print 'Tryout Schedule</a></font>
                        </td>
                </tr>';

// TOUR

$tourquery = "SELECT *
                                FROM theatres_join
                                WHERE prod = $var AND runtype = 'TO'";
$tourresult = mysql_query($tourquery) or die(mysql_error());
$tourrows = mysql_num_rows($tourresult);

print '<tr>
                        <td>';

if(0<>$tourrows)
{
print '<a href="tour.php?var='.$var.'">';
}
else
{
print '<font color="gray">';
}

print 'Tour Schedule</a></font>
                        </td>
                </tr>';

// UNDERSTUDIES

$usquery = "SELECT *
                                FROM cast
                                WHERE prodno = $var AND orig = 'U'";
$usresult = mysql_query($usquery) or die(mysql_error());
$usrows = mysql_num_rows($usresult);

print '<tr>
                        <td>';

if(0<>$usrows)
{
print '<a href="understudies.php?var='.$var.'">';
}
else
{
print '<font color="gray">';
}

print 'Understudies/Swings</a></font>
                        </td>
                </tr>';


$linkquery = "SELECT *
                        FROM links
                        WHERE prodnu = $var";
$linkresult = mysql_query($linkquery) or die(mysql_error());
$linkrows = mysql_num_rows($linkresult);

print '<tr>
                        <td>';

// LINKS

if(0<>$linkrows)
{
print '<a href="links.php?var='.$var.'">';
}
else
{
print '<font color="gray">';
}

print 'Links</a></font>
                        </td>
                </tr>';

$showvar = $prodnav['showno'];
}

print '</table>
                <img src="../../img/dbgraphics/showdetails.gif" border="0" />
                <table width="175" border="0" cellspacing="0" cellpadding="1">';

$shownavquery = "SELECT *
                        FROM shows
                        WHERE showid = $showvar";
$shownavresult = mysql_query($shownavquery) or die(mysql_error());

while ($shownav = mysql_fetch_array($shownavresult))
{

// MAIN

print ' <tr>
                        <td><a href="../shows/index.php?var='.$showvar.'">Main 
Overview</
a></td>
                </tr>';

// AUTHORS

$authorsquery = "SELECT *
                                        FROM authors
                                        WHERE showno = $showvar
                                ORDER BY sortno";
$authorsresult = mysql_query($authorsquery) or die(mysql_error());
$authorsrows = mysql_num_rows($authorsresult);

print ' <tr>
                        <td>';
                        
if(0<>$authorsrows)
{
print '<a href="../shows/authors.php?var='.$showvar.'">';
}
else
{
print '<font color="gray">';
}

print 'Authors</a></font>
                        </td>
                </tr>';

// SOUURCE MATERIAL

print ' <tr>
                        <td>';

if(!empty($shownav["source"]))
{
print '<a href="../shows/source.php?var='.$showvar.'">';
}
else
{
print '<font color="gray">';
}

print 'Source Material</a></font>
                        </td>
                </tr>';

// SYNOPSIS

print ' <tr>
                        <td>';
                        
if(!empty($shownav["synopsis"]))
{
print '<a href="../shows/synopsis.php?var='.$showvar.'">';
}
else
{
print '<font color="gray">';
}

print 'Synopsis</a></font>
                        </td>
                </tr>';

// NOTES

$shownotesquery = "SELECT *
                                        FROM notes
                                        WHERE showno = $showvar";
$shownotesresult = mysql_query($shownotesquery) or die(mysql_error());
$shownotesrows = mysql_num_rows($shownotesresult);

print ' <tr>
                        <td>';
                        
if(0<>$shownotesrows)
{
print '<a href="../shows/notes.php?var='.$showvar.'">';
}
else
{
print '<font color="gray">';
}

print 'Notes</a></font>
                        </td>
                </tr>';

// SCORE

$scorequery = "SELECT *
                                FROM score
                                WHERE showno = $showvar
                        ORDER BY sortno";
$scoreresult = mysql_query($scorequery) or die(mysql_error());
$scorerows = mysql_num_rows($scoreresult);

print ' <tr>
                        <td>';
                        
if(0<>$scorerows)
{
print '<a href="../shows/score.php?var='.$showvar.'">';
}
else
{
print '<font color="gray">';
}

print 'Score Overview</a></font>
                        </td>
                </tr>';

// RELATED

$showrelatedquery = "SELECT * 
                                FROM related
                                WHERE relate_from = $showvar";
$showrelatedresult = mysql_query($showrelatedquery) or die(mysql_error());
$showrelatedrows = mysql_num_rows($showrelatedresult);

print ' <tr>
                        <td>';
                        
if(0<>$showrelatedrows)
{
print '<a href="../shows/related.php?var='.$showvar.'">';
}
else
{
print '<font color="gray">';
}

print 'Related Shows</a></font>
                        </td>
                </tr>';

// LINKS

$linkquery = "SELECT *
                        FROM links
                        WHERE shownu = $showvar";
$linkresult = mysql_query($linkquery) or die(mysql_error());
$linkrows = mysql_num_rows($linkresult);

print ' <tr>
                        <td>';

if(0<>$linkrows)
{
print '<a href="../shows/links.php?var='.$showvar.'">';
}
else
{
print '<font color="gray">';
}

print 'Links</a></font>
                        </td>
                </tr>';
}
print '</table>';

?></td>
                                                                                
                
                <td valign="top" bgcolor="white"><?
print '                                                                         
        
                        <table width="550" border="0" cellspacing="0" 
cellpadding="3">
                                                                                
                
                                <tr>
                                                                                
                
                                        <td valign="top" width="269">';

mysql_connect('x', 'x', 'x');

mysql_select_db('x');

// CAST & STAFF

$authquery = "SELECT * 
                        FROM authors
                        INNER JOIN names ON names.nameid = authors.nameno
                        WHERE showno = $showvar AND orig = 'O' AND overview = 
'X'
                        ORDER BY sortno";
$authresult = mysql_query($authquery) or die(mysql_error());
$authrows = mysql_num_rows($authresult);

$staffquery = "SELECT * 
                        FROM staff
                        INNER JOIN names ON names.nameid = staff.nameno
                        WHERE prodno = $var AND orig = 'O' AND staff_type = 
'ST' AND overview 
= 'X'
                        ORDER BY sortno";
$staffresult = mysql_query($staffquery) or die(mysql_error());
$staffrows = mysql_num_rows($staffresult);

$castquery = "SELECT * 
                        FROM cast
                        INNER JOIN names ON names.nameid = cast.nameno
                        WHERE prodno = $var AND orig = 'O' AND overview = 'X'
                        ORDER BY sortno";
$castresult = mysql_query($castquery) or die(mysql_error());
$castrows = mysql_num_rows($castresult);

if(0<>$authrows||0<>$staffrows||0<>$castrows)
{
print '<p><span class="section_hdr">Overview</span></p>
                <p>An overview of the cast and staff information in the 
FlyRope.com database 
is listed below.</p>
                        <table width="269" border="0" cellspacing="0" 
cellpadding="2">';
        
        // STAFF
        if(0<>$authrows||0<>$staffrows)
        {
        // AUTHORS
                if(0<>$authrows)
                {
                        while ($authrow = mysql_fetch_array($authresult))
                        {
                        print '                                         <tr>
                                                                                
        <td valign="top" width="119">
                                                                                
                <div align="right">
                                                                                
                
        <strong>'.$authrow["role"].'</a></strong><br>';

                                        if(!empty($authrow["paren"]))
                                        {
                                        print ' <i>('.$authrow["paren"].')</i>';
                                        }

                        print '                                                 
        
        </div>
                                                                                
        </td>
                                                                                
        <td valign="top" width="20">
                                                                                
                <div align="center">
                                                                                
                
        ....</div>
                                                                                
        </td>
                                                                                
        <td valign="top" 
width="118"><a 
href="../people/index.php?var='.$authrow["personno"].'">'.$authrow
["name"].'</a>';

                                        if('F'==$authrow["credited"])
                                        {
                                        print '<em><font color="#646464"> 
[uncredited]</font></
em>';
                                        }
                                        
                        print '                                                 
</td>
                                                                                
</tr>';
                        }
                }

        // STAFF
                while ($staffrow = mysql_fetch_array($staffresult))
                {
                print '                                                 <tr>
                                                                                
        <td valign="top" width="119">
                                                                                
                <div align="right">
                                                                                
                
        <strong>'.$staffrow["role"].'</strong><br>';

                                        if(!empty($staffrow["paren"]))
                                        {
                                        print ' 
<i>('.$staffrow["paren"].')</i>';
                                        }

                print '                                                         
        
        </div>
                                                                                
        </td>
                                                                                
        <td valign="top" width="20">
                                                                                
                <div align="center">
                                                                                
                
        ....</div>
                                                                                
        </td>
                                                                                
        <td valign="top" 
width="118"><a 
href="../people/index.php?var='.$staffrow["personno"].'">'.$staffrow
["name"].'</a>';

                                        if('F'==$staffrow["credited"])
                                        {
                                        print '<em><font color="#646464"> 
[uncredited]</font></
em>';
                                        }
                                        
                print '                                                         
</td>
                                                                                
</tr>';
                }
        }
        if(0<>$castrows)
        {
        print '                                                         <tr 
height="25">
                                                                                
        <td height="25"></td>
                                                                                
        <td colspan="2" 
valign="bottom" height="25"><span class="section_hdr">Recording Cast</span></td>
                                                                                
</tr>';
                                                                                
                        while ($castrow = mysql_fetch_array($castresult))
                        {
                        print '                                         <tr>
                                                                                
        <td valign="top">
                                                                                
                <div align="right">
                                                                                
                
        <strong>'.$castrow['role'].'</strong><br>';

                                        if(!empty($castrow["paren"]))
                                        {
                                        print ' <i>('.$castrow["paren"].')</i>';
                                        }

                        print '                                                 
        
        </div></div>
                                                                                
        </td>
                                                                                
        <td valign="top" width="20">
                                                                                
                <div align="center">
                                                                                
                
        ....</div>
                                                                                
        </td>
                                                                                
        <td valign="top"><a href="../
people/index.php?var='.$castrow["personno"].'">'.$castrow['name'].'</a>';

                                        if('F'==$castrow["credited"])
                                        {
                                        print '<em><font color="#646464"> 
[uncredited]</font></
em>';
                                        }
                        print '                                                 
</td>
                                                                                
</tr>';
                        }
        }

print '                 <tr height="25">
                                        <td></td>
                                        <td width="20"></td>
                                        <td valign="bottom"><em><a 
href="full.php?var='.$var.'">
[Full Cast & Staff]</a></td>
                                </tr>
                        </table>';
}
else
{
print 'No cast or staff known for this production.';
}


print '                                                                         
        
                                        </td>
                                                                                
                
                                        <td valign="top" width="269">
                                                                                
                
                                                <p><span 
class="section_hdr">Production Information</
span></p>
                                                                                
                
                                                <blockquote>
                                                                                
                
                                                        <table width="189" 
border="0" cellspacing="0" 
cellpadding="3" bgcolor="#fffacc">
                                                                                
                
                                                                <tr>
                                                                                
                
                                                                        <td>';

$infoquery = "SELECT *, 
                                        DATE_FORMAT(prev_dt, '%M %e, %Y') AS 
previews, 
                                        DATE_FORMAT(open_dt, '%M %e, %Y') AS 
opening, 
                                        DATE_FORMAT(close_dt, '%M %e, %Y') AS 
closing
                                FROM productions
                                WHERE prodid = $var";
$inforesult = mysql_query($infoquery) or die(mysql_error());

while ($info = mysql_fetch_array($inforesult))
{
                                                                                
                
                                                                        
$today = date("Y-m-d");
$show = $info['showno'];

        if('0000-00-00'<>$info['prev_dt'])
        {
        print '<strong>PREVIEWS:</strong> ';
                                
                if(empty($info['prev_txt']))
                {
                print $info['previews'];
                }
                else
                {
                print $info['prev_txt'];
                }
                                
                if(0<>$info['prev_no'])
                {
                print ' <i>('.$info['prev_no'].' preview';
                                        
                        if(1<>$info['prev_no'])
                        {
                        print 's';
                        }
                                        
                print ')</i>';
                }
        }
                                        
        if('0000-00-00'<>$info['open_dt'])
        {
        print '<p><strong>OPENING:</strong> ';
                                
                if(!empty($info['open_txt']))
                {
                print $info['open_txt'];
                }
                else
                {
                print $info['opening'];
                }
        }
                                
        if('0000-00-00'<>$info['close_dt'])
        {
        print '<p><strong>CLOSING:</strong> ';
                                
                if(!empty($info['close_txt']))
                {
                print $info['close_txt'];
                }
                else
                {
                print $info['closing'];
                }
        }
                                
                                
        if(0<>$info['perf_no'])
        {
        print ' <em>('.$info['perf_no'].' performance';
                                
                if(1<>$info['perf_no'])
                {
                print 's';
                }

        print ')</em>';
        }                               
                                
        $venuequery = "SELECT *, DATE_FORMAT(dt_fr, '%c/%e/%y') AS datefrom, 
DATE_FORMAT(dt_to, '%c/%e/%y') AS dateuntil
                                        FROM theatres_join
                                        INNER JOIN theatres_names ON 
theatres_names.theatrenameid = 
theatres_join.name
                                        WHERE prod = $var AND runtype = 'RU'
                                        ORDER BY dt_fr";
        $venueresult = mysql_query($venuequery) or die(mysql_error());
        $venuerows = mysql_num_rows($venueresult);

        if(0<>$venuerows)
        {
        print '<p>';
        
        while ($venue = mysql_fetch_array($venueresult))
        {
        print '<a href="../theatres/index.php?var='.$venue['bldg'].'">'.$venue
['theatrename'].'</a><br>';
        print '<em>(';

                if('T'==$venue['show_fr'])
                {
                print $venue['datefrom'];
                }
                else
                {
                print '?';
                }
                
        print ' - ';
                
                if('T'==$venue['show_to'])
                {
                print $venue['dateuntil'];
                }
                else
                {
                print '?';
                }
                
        print ')</em><br>';
                
                if(!empty($venue["note"]))
                {
                print ' ('.$venue["note"].')';
                }
        }
        }

print '                         <strong>PRODUCTION TYPE:</strong> '.$info
['prod_type'].'<br>
                                        <strong>PRODUCTION STATUS:</strong> ';

                if(empty($info['prod_status']))
                {
                        if($info['close_dt'] <= $today && '0000-00-00' != 
$prod['close_dt'])
                                {
                                print 'Closed';
                                }
                        if($info['open_dt'] <= $today && $info['close_dt'] >= 
$today || 
'0000-00-00' == $info['close_dt'])
                                {
                                print 'Running';
                                }
                        if($info['open_dt']>$today)
                                {
                                print 'Upcoming';
                                }
                }
                else
                {
                print $info['prod_status'];
                }

print '                                                 <br>
                                                                <strong>RUN 
TYPE:</strong> '.$info
['run_type'].'<br>
                                                                
<strong>MARKET:</strong> '.$info
['market'].'<br>';

                        if('0'!=$info['intermissions'])
                        {
                        print '                         
<strong>INTERMISSIONS:</strong> '.$info
['intermissions'].'<br>';
                        }

$versionvar = $info['versionnu'];

$versionquery = "SELECT *
                                        FROM version
                                        WHERE versionid = $versionvar";
$versionresult = mysql_query($versionquery) or die(mysql_error());
$versionrows = mysql_num_rows($versionresult);

if(0<>$versionrows)
{
while ($version = mysql_fetch_array($versionresult))
{
print '<strong>VERSION:</strong> <a href="songs.php?var='.$var.'">'.$version
["version"].'</a>';
}
}


$audioquery = "SELECT *
                                FROM audio
                                WHERE production = $var";
$audioresult = mysql_query($audioquery) or die(mysql_error());
$audiorows = mysql_num_rows($audioresult);

if(0<>$audiorows)
{
print '<p><strong>AUDIO RECORDING(s):</strong></p>
                        <ul>';

while ($audio = mysql_fetch_array($audioresult))
{
print '<li type="square"><a 
href="../audio/index.php?var='.$audio["audioid"].'">'.$audio
["desc"].'</a></li>';
}

print '</ul>';
}
}                                                                               
                
                                                
print '                                                                         
        
                                                                        </td>
                                                                                
                
                                                                </tr>
                                                                                
                
                                                        </table>
                                                                                
                
                                                </blockquote>
                                                                                
                
                                        </td>
                                                                                
                
                                </tr>
                                                                                
                
                                <tr>
                                                                                
                
                                        <td colspan="2" valign="top" 
width="544">
                                                                                
                
                                                <div align="center">
                                                                                
                
                                                        <img 
src="../../img/greyline.gif" alt="" height="1" 
width="544" border="0"></div>';

// MESSAGE BOARD

print '                                                                         
        
                                                <p><span 
class="section_hdr">Message Board</
span></p>
                                                                                
                
                                                <blockquote>';


$boardquery = "SELECT *, 
                                        DATE_FORMAT(lastpostdate, '%c/%e/%y') 
AS dateposted,
                                        DATE_FORMAT(lastpostdate, '%l:%i %p') 
AS timepost
                                FROM mb_main
                                WHERE prodn = $var
                                ORDER BY lastpostdate desc
                                LIMIT 10";
$boardresult = mysql_query($boardquery) or die(mysql_error());
$rows = mysql_num_rows($boardresult);

if(0<>$rows)
{
print '                                                                         
        
                                                        <table width="454" 
border="0" cellspacing="0" 
cellpadding="3">
                                                                                
                
                                                                <tr 
bgcolor="#353535">
                                                                                
                
                                                                        <td 
width="282"><strong><em>Recent 
Posts</em></strong></td>
                                                                                
                
                                                                        <td 
width="160"><strong><em>Posted 
by</em></strong></td>
                                                                                
                
                                                                </tr>';

while ($board = mysql_fetch_array($boardresult))
{

print '                                                                         
        
                                                                <tr 
bgcolor="#f0f0f0">
                                                                                
                
                                                                        <td 
width="282">a href="topic.php?
topic='.$board["mbid"].'&audiono='.$var.'">'.$board["headline"].'</a></td>
                                                                                
                
                                                                        <td 
width="160">'.$board["lastpost"].'</
td>
                                                                                
                
                                                                </tr>';
}

print '                                                                         
        
                                                                <tr>
                                                                                
                
                                                                        <td 
width="282"></td>
                                                                                
                
                                                                        <td 
align="right" width="160"><em>
[more]</em></td>
                                                                                
                
                                                                </tr>
                                                                                
                
                                                        </table>';
}
else
{
print '<p>Be the first to ';


        if (session_is_registered("valid_user"))
        {
        print '<a href="../messageboards/newtopic1.php?prodn_bd='.$var.'">';
        }
        else
        {
        print '<a href="../users/login1.php?must=X">';
        }                                                                       
                
                                                                                


print 'post on this message board</a>.</p>';
}


print '                                                                         
        
                                                </blockquote>
                                                                                
                
                                                <p><img 
src="../../img/greyline.gif" alt="" height="1" 
width="544" border="0"></p>';

// UPDATE

print '                                                                         
        
                                                <p><span 
class="section_hdr">Update Information</
span></p>
                                                                                
                
                                                <blockquote>
                                                                                
                
                                                        <table width="454" 
border="0" cellspacing="0" 
cellpadding="5">
                                                                                
                
                                                                <tr>
                                                                                
                
                                                                        <td 
valign="top">';
                                                                                
                
                                                                        
if (session_is_registered("valid_user"))
{
print '<a href="addupdate.php?var='.$var.'">';
}
else
{
print '<a href="../users/login1.php?must=X">';
}                                                                               
                
                                                                        
                                                                                
                
                                                                        
print '                                                                         
        
                                                                        <img 
src="../../img/common/udpate.gif" 
alt="" height="13" width="48" border="0"></a></td>
                                                                                
                
                                                                        
<td>Report errors and omissions</td>
                                                                                
                
                                                                </tr>
                                                                                
                
                                                        </table>
                                                                                
                
                                                </blockquote>
                                                                                
                
                                        </td>
                                                                                
                
                                </tr>
                                                                                
                
                        </table>';
}

?></td>
                                                                                
                
        </tr>
                                                                                
                </table>
                                                                                
        </td>
                                                                                
</tr>
                                                                        </table>
                                                                </td>
                                                        </tr>
                                                        <tr>
                                                                <td 
bgcolor="#595959">
                                                                        <div 
align="center">
                                                                                
<? include("../../include/
copyright.html");
?></div>
                                                                </td>
                                                        </tr>
                                                </table>
                                        </div>
                                </form>
                        </div>
                </div>
        </body>

</html>



--- In [email protected], Wade Smart <[EMAIL PROTECTED]> wrote:
>
> 10052006 054 GMT-6
> 
> post your code
> 
> On Thu, 2006-10-05 at 13:17 +0000, Jer wrote:
> 
> > I keep getting parse errors on blank lines and lines that don't have any }:
> > 
> > Parse error: parse error, unexpected '}' in 
> > /x/x/x/x/sections/productions/index.php 
on line 
> > 691
> > 
> > What could the problem be? I've rechecked all of the brackets to make sure 
> > that 
they've all 
> > got open and close brackets. But, it's still giving me the errors.
> > 
> > The odd thing is that I'm just reusing this code. I'm redesigning the site 
> > and 
modifying 
> > existing code.
> > 
> > Any suggestions?
> > 
> > 
> > 
> > 
> > 
> > 
> > The php_mysql group is dedicated to learn more about the PHP/MySQL web 
> > database 
possibilities through group learning.  
> > Yahoo! Groups Links
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> 
> 
> [Non-text portions of this message have been removed]
>






The php_mysql group is dedicated to learn more about the PHP/MySQL web database 
possibilities through group learning.  
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/php_mysql/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/php_mysql/join
    (Yahoo! ID required)

<*> To change settings via email:
    mailto:[EMAIL PROTECTED] 
    mailto:[EMAIL PROTECTED]

<*> To unsubscribe from this group, send an email to:
    [EMAIL PROTECTED]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/
 



Reply via email to