<html>
<head><title>DataBase</title>
<link href="style.css" rel="stylesheet" type="text/css">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1251" />
<style type="text/css">
<!--
.style1 {color: Black}
-->
</style>
</head>
<body bgcolor="lightblue">
<form method="get" action="file.php" name="my_form">
<p>
<span class="style1">TitleID</span>
<input type="text" name="TitleID">
</p>
<p>
<span class="style1">Title</span>
<input type="text" name="Title">
</p>
<p>
<span class="style1">Publisher</span>
<input type="text" name="Publisher">
</p>
<p>
<span class="style1">PubDate</span>
<input type="text" name="PubDate">
</p>
<p>
<span class="style1">Edition</span>
<input type="text" name="Edition">
</p>
<p>
<span class="style1">Cost</span>
<input type="text" name="Cost">
</p>
<p>
<span class="style1">ConditionID</span>
<input type="text" name="ConditionID">
</p>
<p>
<span class="style1">Sold</span>
<input type="text" name="Sold">
</p>
<input type="submit" name="submit" value=" Input " >
</form>
<p>
<?php
echo"<font color=white ><b>The Time is </font>";
echo(date("H:i"));
echo"<font color=white> Today </font>";
echo (date(" d F Y "));
?>
<?php
$dbhandle=mysql_connect("localhost", "root", "");
$db=mssql_select_db("BookShop") or die ("Could not select db");
$sql='select * from Books';
$result=mssql_query($sql);
echo"<table border=1% width=100% bordercolor=black>";
$first_line=true;
while ($row=mssql_fetch_array ($result, MYSQL_ASSOC))
{
if($first_line)
{
echo"<tr>";
foreach($row as $id => $value)
echo"<td><b>".htmlspecialchars($id)."</b></td>";
echo"</tr>";
$first_line=false;
}
echo"<tr>";
foreach($row as $value)
echo"<td>".htmlspecialchars($value)."</td>";
echo"</tr>";
}
echo"</table>";
$link2 = mysql_connect('localhost','root','') or die ("Not connected");
mssql_select_db('BookShop') or die ("The database is missed");
if ($_GET['submit'])
{
$TitleID=(real)$_GET['TitleID'];
$Title=(string)$_GET['Title'];
$Publisher=(string)$_GET['Publisher'];
$PubDate=(integer)$_GET['PubDate'];
$Edition=(string)$_GET['Edition'];
$Cost=(double)$_GET['Cost'];
$CondotionID=(real)$_GET['ConditionID'];
$Sold=(string)$_GET['Sold'];
}
else
{
echo "<h1>The form does not submited</h1>";
}
$sql = "INSERT INTO Books (TitleID, Title, Publisher, PubDate, Edition, Cost, ConditionID, Sold)
VALUES ($TitleID, $Title, $Publisher, $PubDate, $Edition, $Cost, $ConditionID, $Sold)";
mysql_query($sql);
mysql_close($link2);
?>
Подскажите пожалуйста, может что не так...