Форум пользователей MySQL

Здраствуйте все есть проблема нужны таблицы MySQl для моих скриптов сам я их нив какую немогу сделать.......
Вот к этим скриптам...:
<?php

$teams=array('Russia','Australia','Nigeria','Croatia','Sweden','Ireland','Paraguay','Poland','Scotland','Cameroon','Turkey','Belgium','Denmark','Greece','Uruguay','Korea','Norway', 'China', 'Finland', 'Bulgaria', 'Romania','Ukraine','Mexico');
$Russia=array('Russia','Cyn4uk','0','0','0','0','0','0','0','0');
$Australia=array('Australia','Lord_of_darkness','0','0','0','0','0','0','0','0');
$Nigeria=array('Nigeria','Lord_of_darkness','0','0','0','0','0','0','0','0');
$Croatia=array('Croatia','RSX','0','0','0','0','0','0','0','0');
$Sweden=array('Sweden','Misha','0','0','0','0','0','0','0','0');
$Ireland=array('Ireland','Alva','0','0','0','0','0','0','0','0');
$Paraguay=array('Paraguay','Vintik','0','0','0','0','0','0','0','0');
$Poland=array('Poland','MRCrowley','0','0','0','0','0','0','0','0');
$Scotland=array('Scotland','Alexey555','0','0','0','0','0','0','0','0');
$Cameroon=array('Cameroon','Deft','0','0','0','0','0','0','0','0');
$Turkey=array('Turkey','Manhunt','0','0','0','0','0','0','0','0');
$Belgium=array('Belgium','Master','0','0','0','0','0','0','0','0');
$Denmark=array('Denmark','eXe','0','0','0','0','0','0','0','0');
$Greece=array('Greece','Cyn4uk','0','0','0','0','0','0','0','0');
$Uruguay=array('Uruguay','DarkVit','0','0','0','0','0','0','0','0');
$Korea=array('Korea','PblrA','0','0','0','0','0','0','0','0');
$Norway=array('Norway','RSX','0','0','0','0','0','0','0','0');
$China=array('China','F06_Dante','0','0','0','0','0','0','0','0');
$Finland=array('Finland','Manhunt','0','0','0','0','0','0','0','0');
$Bulgaria=array('Bulgaria','KuBa','0','0','0','0','0','0','0','0');
$Romania=array('Romania','Juventus','0','0','0','0','0','0','0','0');
$Ukraine=array('Ukraine','Stealer','0','0','0','0','0','0','0','0');
$Mexico=array('Mexico','solyan','0','0','0','0','0','0','0','0');



/* Ñîåäèíåíèå, âûáîð ÁÄ */
$link = mysql_connect('mysql.politen.ru', 'dbu_politen_1', 'скрыто') or die('Could not connect');
mysql_select_db('db_politen_5') or die('Could not select database');


for ($j=0; $j<23; $j+=1) :
$matches=0;
$wins=0;
$draws=0;
$loses=0;
$gz=0;
$gp=0;
$rg=0;
$score=0;
/* Âûïîëíåíèå SQL query */
$r=mysql_query("select * from table_fifa07");
while($row=mysql_fetch_array($r)) {
if ($row[hoz]==$teams[$j]) {
$matches+=1;
if ($row[schh]>$row[schg]) {$wins+=1; $score+=3;}
if ($row[schh]==$row[schg]) {$draws+=1; $score+=1;}
if ($row[schh]<$row[schg]) {$loses+=1;}
$gz=$gz+$row[schh];
$gp=$gp+$row[schg];
}

}
/* Âûïîëíåíèå SQL query */
$r=mysql_query("select * from table_fifa07");
while($row=mysql_fetch_array($r)) {
if ($row[gos]==$teams[$j]) {
$matches+=1;
if ($row[schg]>$row[schh]) {$wins+=1; $score+=3;}
if ($row[schg]==$row[schh]) {$draws+=1; $score+=1;}
if ($row[schg]<$row[schh]) {$loses+=1;}
$gz=$gz+$row[schg];
$gp=$gp+$row[schh];
}
}
$rg=$gz-$gp;
if ($teams[$j]=='Russia') {
$Russia[2]=$matches;$Russia[3]=$wins;$Russia[4]=$draws;$Russia[5]=$loses;$Russia[6]=$gz;$Russia[7]=$gp;$Russia[8]=$rg;$Russia[9]=$score;
}
if ($teams[$j]=='Australia') {
$Australia[2]=$matches;$Australia[3]=$wins;$Australia[4]=$draws;$Australia[5]=$loses;$Australia[6]=$gz;$Australia[7]=$gp;$Australia[8]=$rg;$Australia[9]=$score;
}
if ($teams[$j]=='Nigeria') {
$Nigeria[2]=$matches;$Nigeria[3]=$wins;$Nigeria[4]=$draws;$Nigeria[5]=$loses;$Nigeria[6]=$gz;$Nigeria[7]=$gp;$Nigeria[8]=$rg;$Nigeria[9]=$score;
}
if ($teams[$j]=='Croatia') {
$Croatia[2]=$matches;$Croatia[3]=$wins;$Croatia[4]=$draws;$Croatia[5]=$loses;$Croatia[6]=$gz;$Croatia[7]=$gp;$Croatia[8]=$rg;$Croatia[9]=$score;
}
if ($teams[$j]=='Sweden') {
$Sweden[2]=$matches;$Sweden[3]=$wins;$Sweden[4]=$draws;$Sweden[5]=$loses;$Sweden[6]=$gz;$Sweden[7]=$gp;$Sweden[8]=$rg;$Sweden[9]=$score;
}
if ($teams[$j]=='Ireland') {
$Ireland[2]=$matches;$Ireland[3]=$wins;$Ireland[4]=$draws;$Ireland[5]=$loses;$Ireland[6]=$gz;$Ireland[7]=$gp;$Ireland[8]=$rg;$Ireland[9]=$score;
}
if ($teams[$j]=='Paraguay') {
$Paraguay[2]=$matches;$Paraguay[3]=$wins;$Paraguay[4]=$draws;$Paraguay[5]=$loses;$Paraguay[6]=$gz;$Paraguay[7]=$gp;$Paraguay[8]=$rg;$Paraguay[9]=$score;
}
if ($teams[$j]=='Poland') {
$Poland[2]=$matches;$Poland[3]=$wins;$Poland[4]=$draws;$Poland[5]=$loses;$Poland[6]=$gz;$Poland[7]=$gp;$Poland[8]=$rg;$Poland[9]=$score;
}
if ($teams[$j]=='Scotland') {
$Scotland[2]=$matches;$Scotland[3]=$wins;$Scotland[4]=$draws;$Scotland[5]=$loses;$Scotland[6]=$gz;$Scotland[7]=$gp;$Scotland[8]=$rg;$Scotland[9]=$score;
}
if ($teams[$j]=='Cameroon') {
$Cameroon[2]=$matches;$Cameroon[3]=$wins;$Cameroon[4]=$draws;$Cameroon[5]=$loses;$Cameroon[6]=$gz;$Cameroon[7]=$gp;$Cameroon[8]=$rg;$Cameroon[9]=$score;
}
if ($teams[$j]=='Turkey') {
$Turkey[2]=$matches;$Turkey[3]=$wins;$Turkey[4]=$draws;$Turkey[5]=$loses;$Turkey[6]=$gz;$Turkey[7]=$gp;$Turkey[8]=$rg;$Turkey[9]=$score;
}
if ($teams[$j]=='Belgium') {
$Belgium[2]=$matches;$Belgium[3]=$wins;$Belgium[4]=$draws;$Belgium[5]=$loses;$Belgium[6]=$gz;$Belgium[7]=$gp;$Belgium[8]=$rg;$Belgium[9]=$score;
}
if ($teams[$j]=='Denmark') {
$Denmark[2]=$matches;$Denmark[3]=$wins;$Denmark[4]=$draws;$Denmark[5]=$loses;$Denmark[6]=$gz;$Denmark[7]=$gp;$Denmark[8]=$rg;$Denmark[9]=$score;
}
if ($teams[$j]=='Greece') {
$Greece[2]=$matches;$Greece[3]=$wins;$Greece[4]=$draws;$Greece[5]=$loses;$Greece[6]=$gz;$Greece[7]=$gp;$Greece[8]=$rg;$Greece[9]=$score;
}
if ($teams[$j]=='Uruguay') {
$Uruguay[2]=$matches;$Uruguay[3]=$wins;$Uruguay[4]=$draws;$Uruguay[5]=$loses;$Uruguay[6]=$gz;$Uruguay[7]=$gp;$Uruguay[8]=$rg;$Uruguay[9]=$score;
}
if ($teams[$j]=='Korea') {
$Korea[2]=$matches;$Korea[3]=$wins;$Korea[4]=$draws;$Korea[5]=$loses;$Korea[6]=$gz;$Korea[7]=$gp;$Korea[8]=$rg;$Korea[9]=$score;
}
if ($teams[$j]=='Norway') {
$Norway[2]=$matches;$Norway[3]=$wins;$Norway[4]=$draws;$Norway[5]=$loses;$Norway[6]=$gz;$Norway[7]=$gp;$Norway[8]=$rg;$Norway[9]=$score;
}
if ($teams[$j]=='China') {
$China[2]=$matches;$China[3]=$wins;$China[4]=$draws;$China[5]=$loses;$China[6]=$gz;$China[7]=$gp;$China[8]=$rg;$China[9]=$score;
}
if ($teams[$j]=='Finland') {
$Finland[2]=$matches;$Finland[3]=$wins;$Finland[4]=$draws;$Finland[5]=$loses;$Finland[6]=$gz;$Finland[7]=$gp;$Finland[8]=$rg;$Finland[9]=$score;
}
if ($teams[$j]=='Bulgaria') {
$Bulgaria[2]=$matches;$Bulgaria[3]=$wins;$Bulgaria[4]=$draws;$Bulgaria[5]=$loses;$Bulgaria[6]=$gz;$Bulgaria[7]=$gp;$Bulgaria[8]=$rg;$Bulgaria[9]=$score;
}
if ($teams[$j]=='Romania') {
$Romania[2]=$matches;$Romania[3]=$wins;$Romania[4]=$draws;$Romania[5]=$loses;$Romania[6]=$gz;$Romania[7]=$gp;$Romania[8]=$rg;$Romania[9]=$score;
}
if ($teams[$j]=='Ukraine') {
$Ukraine[2]=$matches;$Ukraine[3]=$wins;$Ukraine[4]=$draws;$Ukraine[5]=$loses;$Ukraine[6]=$gz;$Ukraine[7]=$gp;$Ukraine[8]=$rg;$Ukraine[9]=$score;
}
if ($teams[$j]=='Mexico') {
$Mexico[2]=$matches;$Mexico[3]=$wins;$Mexico[4]=$draws;$Mexico[5]=$loses;$Mexico[6]=$gz;$Mexico[7]=$gp;$Mexico[8]=$rg;$Mexico[9]=$score;
}
endfor;

//Î÷èùàåì òàáëèöó
$ss=mysql_query("delete from table_fifa07_table");
//Âñòàâëÿåì ðåç-òû
$q="INSERT INTO table_fifa07_table(team, nik, matches, wins, draws, loses, gz, gp, rg, score) VALUES ('$Russia[0]','$Russia[1]','$Russia[2]','$Russia[3]','$Russia[4]','$Russia[5]','$Russia[6]','$Russia[7]','$Russia[8]','$Russia[9]')";
mysql_query($q) or die(mysql_error());
$q="INSERT INTO table_fifa07_table(team, nik, matches, wins, draws, loses, gz, gp, rg, score) VALUES ('$Australia[0]','$Australia[1]','$Australia[2]','$Australia[3]','$Australia[4]','$Australia[5]','$Australia[6]','$Australia[7]','$Australia[8]','$Australia[9]')";
mysql_query($q) or die(mysql_error());
$q="INSERT INTO table_fifa07_table(team, nik, matches, wins, draws, loses, gz, gp, rg, score) VALUES ('$Nigeria[0]','$Nigeria[1]','$Nigeria[2]','$Nigeria[3]','$Nigeria[4]','$Nigeria[5]','$Nigeria[6]','$Nigeria[7]','$Nigeria[8]','$Nigeria[9]')";
mysql_query($q) or die(mysql_error());
$q="INSERT INTO table_fifa07_table(team, nik, matches, wins, draws, loses, gz, gp, rg, score) VALUES ('$Croatia[0]','$Croatia[1]','$Croatia[2]','$Croatia[3]','$Croatia[4]','$Croatia[5]','$Croatia[6]','$Croatia[7]','$Croatia[8]','$Croatia[9]')";
mysql_query($q) or die(mysql_error());
$q="INSERT INTO table_fifa07_table(team, nik, matches, wins, draws, loses, gz, gp, rg, score) VALUES ('$Sweden[0]','$Sweden[1]','$Sweden[2]','$Sweden[3]','$Sweden[4]','$Sweden[5]','$Sweden[6]','$Sweden[7]','$Sweden[8]','$Sweden[9]')";
mysql_query($q) or die(mysql_error());
$q="INSERT INTO table_fifa07_table(team, nik, matches, wins, draws, loses, gz, gp, rg, score) VALUES ('$Ireland[0]','$Ireland[1]','$Ireland[2]','$Ireland[3]','$Ireland[4]','$Ireland[5]','$Ireland[6]','$Ireland[7]','$Ireland[8]','$Ireland[9]')";
mysql_query($q) or die(mysql_error());
$q="INSERT INTO table_fifa07_table(team, nik, matches, wins, draws, loses, gz, gp, rg, score) VALUES ('$Paraguay[0]','$Paraguay[1]','$Paraguay[2]','$Paraguay[3]','$Paraguay[4]','$Paraguay[5]','$Paraguay[6]','$Paraguay[7]','$Paraguay[8]','$Paraguay[9]')";
mysql_query($q) or die(mysql_error());
$q="INSERT INTO table_fifa07_table(team, nik, matches, wins, draws, loses, gz, gp, rg, score) VALUES ('$Poland[0]','$Poland[1]','$Poland[2]','$Poland[3]','$Poland[4]','$Poland[5]','$Poland[6]','$Poland[7]','$Poland[8]','$Poland[9]')";
mysql_query($q) or die(mysql_error());
$q="INSERT INTO table_fifa07_table(team, nik, matches, wins, draws, loses, gz, gp, rg, score) VALUES ('$Scotland[0]','$Scotland[1]','$Scotland[2]','$Scotland[3]','$Scotland[4]','$Scotland[5]','$Scotland[6]','$Scotland[7]','$Scotland[8]','$Scotland[9]')";
mysql_query($q) or die(mysql_error());
$q="INSERT INTO table_fifa07_table(team, nik, matches, wins, draws, loses, gz, gp, rg, score) VALUES ('$Cameroon[0]','$Cameroon[1]','$Cameroon[2]','$Cameroon[3]','$Cameroon[4]','$Cameroon[5]','$Cameroon[6]','$Cameroon[7]','$Cameroon[8]','$Cameroon[9]')";
mysql_query($q) or die(mysql_error());
$q="INSERT INTO table_fifa07_table(team, nik, matches, wins, draws, loses, gz, gp, rg, score) VALUES ('$Turkey[0]','$Turkey[1]','$Turkey[2]','$Turkey[3]','$Turkey[4]','$Turkey[5]','$Turkey[6]','$Turkey[7]','$Turkey[8]','$Turkey[9]')";
mysql_query($q) or die(mysql_error());
$q="INSERT INTO table_fifa07_table(team, nik, matches, wins, draws, loses, gz, gp, rg, score) VALUES ('$Belgium[0]','$Belgium[1]','$Belgium[2]','$Belgium[3]','$Belgium[4]','$Belgium[5]','$Belgium[6]','$Belgium[7]','$Belgium[8]','$Belgium[9]')";
mysql_query($q) or die(mysql_error());
$q="INSERT INTO table_fifa07_table(team, nik, matches, wins, draws, loses, gz, gp, rg, score) VALUES ('$Denmark[0]','$Denmark[1]','$Denmark[2]','$Denmark[3]','$Denmark[4]','$Denmark[5]','$Denmark[6]','$Denmark[7]','$Denmark[8]','$Denmark[9]')";
mysql_query($q) or die(mysql_error());
$q="INSERT INTO table_fifa07_table(team, nik, matches, wins, draws, loses, gz, gp, rg, score) VALUES ('$Greece[0]','$Greece[1]','$Greece[2]','$Greece[3]','$Greece[4]','$Greece[5]','$Greece[6]','$Greece[7]','$Greece[8]','$Greece[9]')";
mysql_query($q) or die(mysql_error());
$q="INSERT INTO table_fifa07_table(team, nik, matches, wins, draws, loses, gz, gp, rg, score) VALUES ('$Uruguay[0]','$Uruguay[1]','$Uruguay[2]','$Uruguay[3]','$Uruguay[4]','$Uruguay[5]','$Uruguay[6]','$Uruguay[7]','$Uruguay[8]','$Uruguay[9]')";
mysql_query($q) or die(mysql_error());
$q="INSERT INTO table_fifa07_table(team, nik, matches, wins, draws, loses, gz, gp, rg, score) VALUES ('$Korea[0]','$Korea[1]','$Korea[2]','$Korea[3]','$Korea[4]','$Korea[5]','$Korea[6]','$Korea[7]','$Korea[8]','$Korea[9]')";
mysql_query($q) or die(mysql_error());
$q="INSERT INTO table_fifa07_table(team, nik, matches, wins, draws, loses, gz, gp, rg, score) VALUES ('$Norway[0]','$Norway[1]','$Norway[2]','$Norway[3]','$Norway[4]','$Norway[5]','$Norway[6]','$Norway[7]','$Norway[8]','$Norway[9]')";
mysql_query($q) or die(mysql_error());
$q="INSERT INTO table_fifa07_table(team, nik, matches, wins, draws, loses, gz, gp, rg, score) VALUES ('$China[0]','$China[1]','$China[2]','$China[3]','$China[4]','$China[5]','$China[6]','$China[7]','$China[8]','$China[9]')";
mysql_query($q) or die(mysql_error());
$q="INSERT INTO table_fifa07_table(team, nik, matches, wins, draws, loses, gz, gp, rg, score) VALUES ('$Finland[0]','$Finland[1]','$Finland[2]','$Finland[3]','$Finland[4]','$Finland[5]','$Finland[6]','$Finland[7]','$Finland[8]','$Finland[9]')";
mysql_query($q) or die(mysql_error());
$q="INSERT INTO table_fifa07_table(team, nik, matches, wins, draws, loses, gz, gp, rg, score) VALUES ('$Bulgaria[0]','$Bulgaria[1]','$Bulgaria[2]','$Bulgaria[3]','$Bulgaria[4]','$Bulgaria[5]','$Bulgaria[6]','$Bulgaria[7]','$Bulgaria[8]','$Bulgaria[9]')";
mysql_query($q) or die(mysql_error());
$q="INSERT INTO table_fifa07_table(team, nik, matches, wins, draws, loses, gz, gp, rg, score) VALUES ('$Romania[0]','$Romania[1]','$Romania[2]','$Romania[3]','$Romania[4]','$Romania[5]','$Romania[6]','$Romania[7]','$Romania[8]','$Romania[9]')";
mysql_query($q) or die(mysql_error());
$q="INSERT INTO table_fifa07_table(team, nik, matches, wins, draws, loses, gz, gp, rg, score) VALUES ('$Ukraine[0]','$Ukraine[1]','$Ukraine[2]','$Ukraine[3]','$Ukraine[4]','$Ukraine[5]','$Ukraine[6]','$Ukraine[7]','$Ukraine[8]','$Ukraine[9]')";
mysql_query($q) or die(mysql_error());
$q="INSERT INTO table_fifa07_table(team, nik, matches, wins, draws, loses, gz, gp, rg, score) VALUES ('$Mexico[0]','$Mexico[1]','$Mexico[2]','$Mexico[3]','$Mexico[4]','$Mexico[5]','$Mexico[6]','$Mexico[7]','$Mexico[8]','$Mexico[9]')";
mysql_query($q) or die(mysql_error());
?>


<p align="center"><b><font style="font-size: 13pt"><br>
<br>
</font><font size="3">Òåêóùàÿ òàáëèöà ÷åìïèîíàòà</font></b></p>
<center>

<?php
/* Ïå÷àòü ðåçóëüòàòîâ â HTML */
echo "<table heih border=\"1\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse\" bordercolor=\"#DD8500\">";
echo "<tr>";
echo "<td width=\"60\" align=\"center\" bgcolor=\"#C0C0C0\"><b>Ìåñòî</b></td>";
echo "<td width=\"110\" align=\"center\" bgcolor=\"#C0C0C0\"><b>Êîìàíäà</b></td>";
echo "<td width=\"140\" align=\"center\" bgcolor=\"#C0C0C0\"><b>Íèê</b></td>";
echo "<td width=\"50\" align=\"center\" bgcolor=\"#C0C0C0\"><b>Ì</b></td>";
echo "<td width=\"50\" align=\"center\" bgcolor=\"#9B9BFF\"><b>Â</b></td>";
echo "<td width=\"50\" align=\"center\" bgcolor=\"#88FF88\"><b>Í</b></td>";
echo "<td width=\"50\" align=\"center\" bgcolor=\"#FF8484\"><b>Ï</b></td>";
echo "<td width=\"55\" align=\"center\" bgcolor=\"#C0C0C0\"><b>ÃÇ</b></td>";
echo "<td width=\"55\" align=\"center\" bgcolor=\"#C0C0C0\"><b>ÃÏ</b></td>";
echo "<td width=\"55\" align=\"center\" bgcolor=\"#C0C0C0\"><b>ÐÃ</b></td>";
echo "<td width=\"70\" align=\"center\" bgcolor=\"#FFFF9D\"><b>Î×Ê</b></td>";
$r=mysql_query("select * from table_fifa07_table order by 'score' desc,'rg' DESC");
$i=0;
while($row=mysql_fetch_array($r)) {
$i+=1;
echo "<tr>\n";
echo "\t<td><b>&nbsp;&nbsp;&nbsp;$i</b></center></td>\n";
echo "\t<td><b>&nbsp;&nbsp;&nbsp;<a target=\"_blank\" href=\"details.php?teamfd=$row[team]\">$row[team]</b></a></center></td>\n";
echo "\t<td><b>&nbsp;&nbsp;&nbsp;$row[nik]</b></center></td>\n";
echo "\t<td><b><center>$row[matches]</b></center></td>\n";
echo "\t<td><b><center>$row[wins]</b></center></td>\n";
echo "\t<td><b><center>$row[draws]</b></center></td>\n";
echo "\t<td><b><center>$row[loses]</b></center></td>\n";
echo "\t<td><b><center>$row[gz]</b></center></td>\n";
echo "\t<td><b><center>$row[gp]</b></center></td>\n";
echo "\t<td><b><center>$row[rg]</b></center></td>\n";
echo "\t<td><b><center>$row[score]</b></center></td>\n";
}
echo "</tr>\n </table>\n";
echo "<br>";
?>

</center>




Файл добавления результата:
<?php

// âûâîäèì ôîðìó
if ($dob==null) {include_once('dobav007.htm');}

if ($dob<>null) {

/* Ñîåäèíåíèå, âûáîð ÁÄ */

$link = mysql_connect('mysql.politen.ru', 'dbu_politen_1', 'скрыто') or die('Could not connect');
mysql_select_db('db_politen_5') or die('Could not select database');

/* Âûïîëíåíèå SQL query */
$query = 'SELECT * FROM table_fifa07';
$result = mysql_query($query) or die('Query failed');

//Îïðåäåëÿåì òåêóùóþ äàòó
$datamatcha=date("d.m.y");

// çàïèñûâàåì äàííûå ïåðâîé ôîðìû â ÁÄ
$q="INSERT INTO table_fifa07(hoz, nikh, gos, nikg, vid, schh, schg, dt) VALUES ('$hozaeva', '$hozaevanik', '$gosti', '$gostinik', '$vidm', '$golihoz', '$goligos', '$datamatcha')";
mysql_query($q) or die(mysql_error());

echo "<p align=\"center\"><b>Результат успешно добавлен!</b>";
echo "<br>";
echo "<b><a href=\"http://fifa07.politen.ru/add_res_fifa.php\">Добавить еще?</a></b></p>";
}

?>

файл 'dobav007.htm'

<html>

<head>
<meta http-equiv="Content-Language" content="ru">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1251">
<title>Äîáàâèòü ðåçóëüòàò ìàò÷à</title>
</head>

<body>

<p align="center"><b>Äîáàâèòü ðåçóëüòàò ìàò÷à:</b></p>

<form method="POST" action="add_res_fifa.php">
<p align="left">
<b>Õîçÿåâà:&nbsp;&nbsp;&nbsp;&nbsp; <select size="1" name="hozaeva">
<option>Russia</option>
<option>Australia</option>
<option>Nigeria</option>
<option>Croatia</option>
<option>Sweden</option>
<option>Ireland</option>
<option>Paraguay</option>
<option>Poland</option>
<option>Scotland</option>
<option>Cameroon</option>
<option>Turkey</option>
<option>Belgium</option>
<option>Denmark</option>
<option>Greece</option>
<option>Uruguay</option>
<option>Korea</option>
<option>Norway</option>
<option>China</option>
<option>Finland</option>
<option>Bulgaria</option>
<option>Romania</option>
<option>Ukraine</option>
<option>Mexico</option>
</select></b></p>

<p align="left">
<b>Íèê èãðîêà êîìàíäû õîçÿåâ:&nbsp;&nbsp;&nbsp;&nbsp;
<select size="1" name="hozaevanik">
<option>Cyn4uk</option>
<option>Lord_of_darkness</option>
<option>Lord_of_darkness</option>
<option>RSX</option>
<option>Misha</option>
<option>Alva</option>
<option>Vintik</option>
<option>MRCrowley</option>
<option>Alexey555</option>
<option>Deft</option>
<option>Manhunt</option>
<option>Master</option>
<option>eXe</option>
<option>Cyn4uk</option>
<option>DarkVit</option>
<option>PblrA</option>
<option>RSX</option>
<option>F06_Dante</option>
<option>Manhunt</option>
<option>KuBa</option>
<option>Juventus</option>
<option>Stealer</option>
<option>solyan</option>
</select></b></p>

<p align="left">
<b>Ãîñòè:&nbsp;&nbsp;&nbsp;&nbsp; <select size="1" name="gosti">
<option>Russia</option>
<option>Australia</option>
<option>Nigeria</option>
<option>Croatia</option>
<option>Sweden</option>
<option>Ireland</option>
<option>Paraguay</option>
<option>Poland</option>
<option>Scotland</option>
<option>Cameroon</option>
<option>Turkey</option>
<option>Belgium</option>
<option>Denmark</option>
<option>Greece</option>
<option>Uruguay</option>
<option>Korea</option>
<option>Norway</option>
<option>China</option>
<option>Finland</option>
<option>Bulgaria</option>
<option>Romania</option>
<option>Ukraine</option>
<option>Mexico</option>
</select></b></p>

<p align="left">
<b>Íèê èãðîêà êîìàíäû ãîñòåé:&nbsp;&nbsp;&nbsp;&nbsp;
<select size="1" name="gostinik">
<option>Cyn4uk</option>
<option>Lord_of_darkness</option>
<option>Lord_of_darkness</option>
<option>RSX</option>
<option>Misha</option>
<option>Alva</option>
<option>Vintik</option>
<option>MRCrowley</option>
<option>Alexey555</option>
<option>Deft</option>
<option>Manhunt</option>
<option>Master</option>
<option>eXe</option>
<option>Cyn4uk</option>
<option>DarkVit</option>
<option>PblrA</option>
<option>RSX</option>
<option>F06_Dante</option>
<option>Manhunt</option>
<option>KuBa</option>
<option>Juventus</option>
<option>Stealer</option>
<option>solyan</option>
</select></b></p>

<p align="left"><b>Âèä ìàò÷à:&nbsp;&nbsp;&nbsp;&nbsp; <select size="1" name="vidm">
<option selected>×åìïèîíàò</option>
<option>Êóáîê</option>
</select></b></p>

<p align="left"><b>Ãîëû õîçÿåâ:&nbsp;&nbsp;&nbsp;&nbsp;
<select size="1" name="golihoz">
<option selected>0</option>
<option>1</option>
<option>2</option>
<option>3</option>
<option>4</option>
<option>5</option>
<option>6</option>
<option>7</option>
<option>8</option>
<option>9</option>
<option>10</option>
<option>11</option>
<option>12</option>
<option>13</option>
<option>14</option>
<option>15</option>
</select></b></p>

<p align="left"><b>Ãîëû ãîñòåé:&nbsp;&nbsp;&nbsp;&nbsp;
<select size="1" name="goligos">
<option selected>0</option>
<option>1</option>
<option>2</option>
<option>3</option>
<option>4</option>
<option>5</option>
<option>6</option>
<option>7</option>
<option>8</option>
<option>9</option>
<option>10</option>
<option>11</option>
<option>12</option>
<option>13</option>
<option>14</option>
<option>15</option>
</select></b></p>

<p align="left"><input type="submit" value="Äîáàâèòü" name="dob"></p>

</form>

</body>

</html>




<?php

/* Ñîåäèíåíèå, âûáîð ÁÄ */
$link = mysql_connect('mysql.politen.ru', 'dbu_politen_1', 'скрыто') or die('Could not connect');
mysql_select_db('db_politen_5') or die('Could not select database');

/* Âûïîëíåíèå SQL query */
$query = 'SELECT * FROM table_fifa07';
$result = mysql_query($query) or die('Query failed');

//Äåòàëèçàöèÿ ìàò÷à
if ($matchid<>null) {
$r=mysql_query("select * from table_fifa07");
while($row=mysql_fetch_array($r)) {
if ($row[match_id]==$matchid) {
echo "<br>";
echo "<b>Õîçÿåâà:</b>&nbsp;&nbsp;"; echo $row[hoz]; echo "&nbsp;("; echo $row[nikh]; echo ")";
echo "<br>";
echo "<b>Ãîñòè:</b>&nbsp;&nbsp;"; echo $row[gos]; echo "&nbsp;("; echo $row[nikg]; echo ")";
echo "<br>";
echo "<b>Ñ÷åò:</b>&nbsp;&nbsp;"; echo $row[schh]; echo ":"; echo $row[schg];
echo "<br>";
echo "<b>Äàòà ìàò÷à:</b>&nbsp;&nbsp;"; echo $row[dt];
}
}
}

//Äåòàëèçàöèÿ èãð êîìàíäû
if ($teamfd<>null) {
$r=mysql_query("select * from table_fifa07");
echo "<table align=\"center\" border=\"1\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse\" bordercolor=\"#DD8500\">\n"; echo "<tr>\n";
echo "\t<td bgcolor=\"#C0C0C0\" width=\"140\"><center><b>Õîçÿåâà</b></center></td>\n";
echo "\t<td bgcolor=\"#C0C0C0\" width=\"50\"><center><b>Ñ÷åò</b></center></td>\n";
echo "\t<td bgcolor=\"#C0C0C0\" width=\"140\"><center><b>Ãîñòè</b></center></td>\n";
echo "\t<td bgcolor=\"#C0C0C0\" width=\"100\"><center><b>Ïîäðîáíåå</b></center></td>\n</b></center>";
while($row=mysql_fetch_array($r)) {
if (($row[hoz]==$teamfd) or ($row[gos]==$teamfd)) {
echo "<tr>\n";
echo "\t<td><b>&nbsp;&nbsp;&nbsp;$row[hoz]</b></center></td>\n";
echo "\t<td><b><center>$row[schh]:$row[schg]</center></b></center></td>\n";
echo "\t<td><b>&nbsp;&nbsp;&nbsp;$row[gos]</b></center></td>\n";
echo "\t<td><center><a target=\"_blank\" href=\"details.php?matchid=$row[match_id]\"><img border=\"0\" src=\"images/icon_detail.gif\" width=\"18\" height=\"9\"></a></center></td>\n";
}
}
}

?>

Результаты поседних 5 матчей:

<?php

echo "<p align=\"center\"><b>Ïîñëåäíèå 5 èãð</b></p>";

/* Ñîåäèíåíèå, âûáîð ÁÄ */
$link = mysql_connect('mysql.politen.ru', 'dbu_politen_1', 'скрыто') or die('Could not connect');
mysql_select_db('db_politen_5') or die('Could not select database');

/* Âûïîëíåíèå SQL query */
$query = 'SELECT * FROM table_fifa07';
$result = mysql_query($query) or die('Query failed');

$kolvo=mysql_num_rows($result);
$nk=$kolvo-5;

/* Ïå÷àòü ðåçóëüòàòîâ â HTML */
echo "<table align=\"center\" border=\"1\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse\" bordercolor=\"#DD8500\">\n"; echo "<tr>\n";
echo "\t<td bgcolor=\"#C0C0C0\" width=\"140\"><center><b>Õîçÿåâà</b></center></td>\n";
echo "\t<td bgcolor=\"#C0C0C0\" width=\"50\"><center><b>Ñ÷åò</b></center></td>\n";
echo "\t<td bgcolor=\"#C0C0C0\" width=\"140\"><center><b>Ãîñòè</b></center></td>\n";
echo "\t<td bgcolor=\"#C0C0C0\" width=\"100\"><center><b>Ïîäðîáíåå</b></center></td>\n</b></center>";
$r=mysql_query("select * from table_fifa07 where match_id>$nk");
while($row=mysql_fetch_array($r)) {
echo "<tr>\n";
echo "\t<td><b>&nbsp;&nbsp;&nbsp;$row[hoz]</b></center></td>\n";
echo "\t<td><b><center>$row[schh]:$row[schg]</center></b></center></td>\n";
echo "\t<td><b>&nbsp;&nbsp;&nbsp;$row[gos]</b></center></td>\n";
echo "\t<td><center><a target=\"_blank\" href=\"details.php?matchid=$row[match_id]\"><img border=\"0\" src=\"images/icon_detail.gif\" width=\"18\" height=\"9\"></a></center></td>\n";
}
echo "</tr>\n </table>\n";
echo "<br>";

?>

Файл главной страницы (index.php)

<?php include("title.php"); ?>

<html>

<head>
<meta http-equiv="Content-Language" content="ru">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1251">
<title><?php echo $title; ?></title>
<link rel="stylesheet" type="text/css" href="site.css">
</head>

<body topmargin="0" leftmargin="0">

<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%">
<tr>
<td width="100%">
<?php include("top.php"); ?>
</td>
</tr>
</table>

<div align="center">

<table height="100% border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="99%">
<tr>
<td valign="top" width="20%">
<?php include("menu.php"); ?>
</td>
<td width="80%" valign="top">
<?php if ($v==null) {include("table.php"); echo "<br>"; include("last5.php");}
if (($v==2) and ($p==1)) {include("teamsplayers.htm");}
if (($v==2) and ($p==3)) {include("rules.php");}
if (($v==1) and ($ch==2)) {include("games.htm");}
if (($v==1) and ($ch==3)) {include("table.php");}
if (($v==1) and ($ch==4)) {include("cup.php");}
?>
</td>
</tr>
</table>

</div>

</body>

</html>




Кто может помочь отпишитесь в моей теме!))Спасибо за внимание!

P.S Язык пытался перекодировать и получилась такая лобуден не понятная...))