document.open();document.writeln('
');document.writeln('
<?php');document.writeln('    ');document.writeln('    // grab multiple tables');document.writeln('    $q = "SELECT c.Titles_id, c.Titles_name, c.stage, a.authorFirstname, a.authorLastname, a.authorEmail, e.editorFirstname, e.editorLastname');document.writeln('FROM currentTitles AS c, authors AS a, editors AS e');document.writeln('WHERE c.authorId = a.authorId');document.writeln('AND c.editorId = e.editorId";');document.writeln('    if ($results = $mysql->query($q))');document.writeln('    {');document.writeln('        while ($records = $results->fetch_object())');document.writeln('        {');document.writeln('        	$bgColor = $bgColor == 'back1' ? 'back2' : 'back1'; // Alternate colors in divs');document.writeln('            echo "<div id='item' class='$bgColor'><p>Title: ".$records->currentTitles_name."</p>');document.writeln('    					Author: <a href='mailto:" . $records->authorEmail . "'>" .$records->authorFirstname." " . $records->authorLastname . "</a><br />');document.writeln('						<h4 id='" . $records->Titles_id . "'>Stage: " . $records->stage . "</h4>";');document.writeln('						if($access == "admin") { echo "<input type='text' name='stage' value='" . $records->stage . "' />"; }');document.writeln('						echo "<p>Editor: " . $records->editorFirstname . " " . $records->editorLastname . "</div>\\n";');document.writeln('        }');document.writeln('    }');document.writeln('?>');document.writeln('
');document.writeln('');document.writeln('');document.writeln('
');document.close();