A bit difficult to debug this without the file included (config.php); providing the error message would also be helpful.
At first glance, I'm just wondering what does the dot mean in the table name used in the FROM clause:
FROM school.physics_chris_rockets
It shouldn't generate a php syntacs error message, but I'm afraid that query wont work
boyan --
Jacob Hackamack wrote:
Currently there seems to be some problem with syntax of some sort, for some reason I keep getting thrown back parse errors, commenting out the lines just moves the parse error line around. If anybody has any help thanks in advance.
<?php
include('config.php');
$Period = $_POST["Period"]; $Name = $_POST["Name"];
$conn = mysql_connect ( $dbhost , $dbuser , $dbpass ); $sql_select = 'SELECT * FROM school.physics_chris_rockets WHERE Period LIKE '.$Period.' AND Visible LIKE "Y" ORDER by Position, Name, Date'; $result = mysql_query($sql_select);
echo '<title>Physics Sign-Up Input</title>'; echo ' <form action="processinfo.php" method="post" name="Insert_Record">'; echo ' <input type=hidden name=Period value="'.$Period.'">'; echo ' <input type=hidden name=Name value="'.$Name.'">'; echo ' <h2>Welcome '.$Name.', '; echo ' <table border=1></table>';
$Space = ''; $Data = $dataRow[1] ;
echo' <th scope="col">Position</th>'; echo' <th scope="col">Openings</th>'; echo' <br>';
while ( $dataRow = mysql_fetch_row ( $result ) ) {
if ($Space != $dataRow[3])
{
echo ' <br>';
echo ' <br>';
echo '<br>'.$dataRow[3].'<br>';
$Space = $dataRow[3] ;
}
else
{
echo '<td></td>';
}
if ($Data == "")
{
echo "<td>Open</td>";
}
else
{
echo '<br>'.$dataRow[1].'<br>';
}
}
echo ' </tr>'; echo ' </table>'; echo ' <div align="right">'; echo ' <p><input type="submit" name="submit" value="Sign Up" tabindex="12"></p>'; echo ' </form>';
?>
Jacob
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
