Курсовая работа: Создание сайта "Красная книга"
printf("<td>%d",$myrow["Name_Sort"],"</tr>");
}
}
//Найти по семейству
if (@$find6F)
{
?>
<div align=center>
<FORM name="mean" method="post" action="<? echo $PHP_SELF?>">
<br>
Введите семейство:<br>
<input type="text" name = "Kingdom"> <br>
<input type="submit" name = "find4K" value="Найти"><br>
</FORM>
</div>
<?
}
if(@$find6А)
{
if (empty($Family))
{
print("<div align=center><h1>Пожалуйста, заполните ячейку!</div></h1>") ;
exit();
}
require_once("connection.php");
$sql ="SELECT ID_Creature, Rus_Name, Lat_Name, Date, Name_Kingdom, Name_Class, Name_Family, Name_Sort FROM (((MAIN join 1_Kingdom on MAIN.ID_Kingdom = 1_Kingdom.ID_Kingdom) join 2_Class on MAIN.ID_Class = 2_Class.ID_Class) join 3_Family on MAIN.ID_Family = 3_Family.ID_Family) join 4_Sort on MAIN.ID_Sort = 4_Sort.ID_Sort WHERE ID_Creature LIKE '%$Name_Family%'";
$result = mysql_query($sql);
?>
<br>