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/
