whoisquilty -
There is, in fact, an extra closing '}' at the very end of the large
php code block.
Mike
On 10/6/2006, "Mike Franks" <[EMAIL PROTECTED]> wrote:
>whoisquilty -
>
>As Rob mentioned, it is really (REALLY) difficult to attempt to read the
>code because of all the line feeds induced by the email process. A url
>to the actual file would be very helpful. Of course, if any of these
>line feeds actually exists in your code, you've got a great many
>problems.
>
>One thing that jumped out at me were several places in the code that
>could yield bad or unterminated html syntax, depending on the results
>returned from the data base. Here's one example:
>
>***************
>
>// 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>';
>
>***************
>
>This code produces one of two results.
>If the query returns 1 or more rows:
>
><tr><td><a href="notes.php?var='.$var.'">Production
>Notes</a></font></td></tr>
>
>If the query returns 0 rows:
>
><tr><td><font color="gray">Production Notes</a></font></td></tr>
>
>In each case, you'll have an extra "closing" element tag - either
></font> or </a>. InternetExplorer may simply ignore these, but I
>wouldn't rely on a "loose" browser to compensate for bad html.
>
>There are many cases in the code where this occurs - they're easily
>found if you search on </a></font>. Each one is a potential problem, but
>I doubt any of them are causing the problem you originally reported.
>
>Mike
>
>
>
>On 10/6/2006, "whoisquilty" <[EMAIL PROTECTED]> wrote:
>
>>You're right, James. 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], James Keeline <[EMAIL PROTECTED]> wrote:
>>>
>>> > > On 10/5/2006, "whoisquilty" <whoisquilty@> 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?
>>>
>>>
>>> > --- In [email protected], "Mike Franks" <mike@> wrote:
>>> > >
>>> > > Also check for open/close quotes (strings that aren't ended). This is
>>> > > easiest if you have a PHP-aware editor that uses colors to highlight
>>> > > syntax.
>>> > >
>>> > > Mike
>>>
>>>
>>> --- whoisquilty <[EMAIL PROTECTED]> wrote:
>>> > I've checked the quotes around area of the problem. Everything seems
>>> > normal.
>>> >
>>> > Again, I haven't changed any of the code that is giving me an error.
>>>
>>>
>>> I don't think anyone can help you on this without seeing some code. Mike
>>> had
>>> the same suggestion I have about checking both single and double quotes and
>>> parentheses. Somehow you haven't closed everything before you tried to
>>> open a
>>> curly brace set. An extra semicolon could be an issue as well. There are
>>> too
>>> many possibilities to try to second-guess it. Supply some code +/- the line
>>> that PHP is complaining about and someone can surely spot it faster than
>>> "playing 20 questions".
>>>
>>> James
>>>
>>
>>
>>
>>
Community email addresses:
Post message: [email protected]
Subscribe: [EMAIL PROTECTED]
Unsubscribe: [EMAIL PROTECTED]
List owner: [EMAIL PROTECTED]
Shortcut URL to this page:
http://groups.yahoo.com/group/php-list
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/php-list/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/php-list/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/
