There must be an issue with your browser. They are there in both my original
and in my
post as viewed on my screen. That's viewing in two different browsers and in my
HTML
editor.
As I said before, that code was also copied and pasted from another source into
the
different file.
The only changes being that I broken the <? ?> block into three separate parts
for ease
while editing the HTML. I've made sure that the { } are all paired and I don't
see a problem
there.
If I had been missing quotes around the links, it wouldn't have worked in the
original file.
There must be another problem that I can't find.
Any suggestions on what that problem might be would be most appreciated.
--- In [email protected], kevin myers <[EMAIL PROTECTED]> wrote:
>
> well while looking over all the code is every post so far, there is not a
> single opening
quote on any of the links
>
> Jer <[EMAIL PROTECTED]> wrote: I'm not
> seeing that. In my original file
and in the version posted in my last message, the
> quote is there.
>
> --- In [email protected], kevin myers <shaggy2dope2126@> wrote:
> >
> > check your quotes, <td valign="top"
> > width="118"> <a href="http://mail.yahoo.com/config/login?/"../people/
> index.php?
> var='.$authrow[ "personno" ].'">'.$authrow
> > ["name"].'</ a>';
> > is the text from lines 686 to 689, and there was a quote missing right
> after the =
sign
> at <a href = http://
> >
> > Jer <whoisquilty@> wrote: 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 <wade@> 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]
> > >
> >
> >
> >
> >
> >
> >
> > ---------------------------------
> > Talk is cheap. Use Yahoo! Messenger to make PC-to-Phone calls. Great
> rates starting
at
> 1ยข/min.
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
>
> ---------------------------------
> How low will we go? Check out Yahoo! Messenger's low PC-to-Phone call rates.
>
> [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/
