Курсовая работа: Создание сайта "Красная книга"

<?php

while ($myrow = mysql_fetch_array($result))

{

printf("<tr><td><H7>%d",$myrow["ID_Creature"],"</h7></td></tr>");

printf("<td>%s",$myrow["Rus_Name"],"</tr>");

printf("<td>%s",$myrow["Lat_Name"],"</tr>");

printf("<td>%d",$myrow["Date"],"</tr>");

printf("<td>%s",$myrow["ID_Kingdom"],"</tr>");

printf("<td>%d",$myrow["ID_Class"],"</tr>");

printf("<td>%d",$myrow["ID_Family"],"</tr>");

printf("<td>%d",$myrow["ID_Sort"],"</tr>");

printf("<td>%d",$myrow["ID_Kind"],"</tr>");

printf("<td>%d",$myrow["ID_Region"],"</tr>");

printf("<td>%d",$myrow["Population"],"</tr>");

}

}

?>

<?php

}

if (@$stnew)

{

require("connect.php");

mysql_query("INSERT INTO Students (StudID,StudName,GroupNum) VALUES ('$stnum','$stname','$grnum')");

mysql_query("INSERT INTO MarkJournal(SubjID, LTypeID, StudID, LNumb)

SELECT SubjID, LTypeID, StudID, LNumb FROM Plan JOIN Students WHERE StudID = '$stnum' ");

$result = mysql_query("SELECT * FROM Students WHERE StudName LIKE '%$stname%'");

?>

<divalign=center><H4>Добавлена запись:</H4></div><br>

<div align=center><table border = 1>